Check if field is Null [SOLVED]

[runs]

How could a check whether a field is null in the script section?

I tried  [field]= nil but arises an error that nil does not exits. Also try [field].IsNull but an error too.

Thanks.

[Thaddy]

Need more info, preferably code that fails where you expect it to work.

[runs]

Need more info, preferably code that fails where you expect it to work.

for example,

if [DataMod.DsoPrint."Substitute_ID"] = nil then
    MmoSubstituted.Visible:=True;

I get an "undefined symbol" error

[Thaddy]

That is not a serious reply.

[korba812]

Unfortunately, LazReport converts a database field value from null to an empty string or zero (depending on the field type). Try using the OnGetValue event.

[runs]

Unfortunately, LazReport converts a database field value from null to an empty string or zero (depending on the field type). Try using the OnGetValue event.

Yes, it converts it to an integer, 0 for null. So it is mandatory to check for >0 to not null.

Thanks!