Detemining an incoming NULL Value

rbuser

I would like to catch incoming NULL values in RAP.

The field type is INTEGER.

It is NULL in the database, but seems to be "0" in RAP.

E.g.

IF aa_property['Image1Id'] <> NULL THEN
Image1.Picture.LoadFromFile('Test.jpg');

ALWAYS tries to load a picture because I can't check for NULL, and 0 is a
valid value for the field. (in other words if the value is 0 then I want to
use it)

Thanks.

nicocizik

----------------------------------------------
Tech Tip: RAP: Checking for Null Data Values
----------------------------------------------

The DataPipeline.FieldObjects[] array property provides access to the
TppField objects. TppField has an IsNull boolean property.

The notation is DataPipeline.FieldObjects['FieldName'].IsNull

example:

if Customer.FieldObjects['Addr1'].IsNull then
ShowMessage('field value is null');


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com