Calculated FlowField --- how to get boolean from Blob

Huebi

I have problems of automatic detection of a picture being present in in a record set. I would like to have a boolean show, if there is a picture present. as I am new to Navision, I tried FlowField Calculation, but the functions available don't seem to fit my needs.
Can anybody help.

SteveO

You could try the HASVALUE command

Syntax: Boolean := Record.BLOBField.HASVALUE();

(I can't remember whether or not you need to do a calcfields first... eg. Record.CALCFIELDS(BLOBField);)

Hope this helps you out a bit.

Huebi

Could you point me in the direction of where to put this?

NaviTools.com

Hi,

In OnValidate() trigger of your BLOB field (I think SteveO had this in mind )

Huebi

Thanks for the help, i got it working now.