need help with calculated field

Huebi

I want to show if a recordset contains a picture (Blob field) in another field, but as i am new to navision, i couldn't get the desired effect from the available functions in calculated fields.
Can anyody help?

pdj

I'm not sure I understand what you mean, but I guess you wish to make a flowfield that is of type lookup to a BLOB field?

That is not possible, because BLOB fields are very related to flowfields (i.e. you need to do a calcfields before exporting it). And just as you can't make a flowfield based on a flowfield you can't base it on a BLOB either.

Depending on how you wish to use it, you might be able to solve it by creating a function on the table instead. You can easily show the output of the function directly on a form, however you can't set a filter on it.

Arhontis

Hi,

Since BLOB fields are managed thru Import/Export and Clear, you can make another field boolean, editable-false and change its value in the onvalidate trigger of your BLOB by using the HASVALUE of the BLOB.


"Keep it simple."

NaviTools.com

Hi uebi,

Why two posts about the same thing

http://www.mibuso.com/forum/viewtopic.php?t=4304

At least link them.

Huebi

:oops: sorry for the crosspost.