Testing for Database Nulls

rbuser

Hi,

What is the best way to test for nulls in RAP?

My scenario is I have 3 columns I wish to use as follows

if col1 not equal nulls then use its value
else if col2 not equal null then use its value
else if col3 not equal nulls then use its value
else output some text.

I cannot find anything with some kind of function to test for nulls.
Any help much appreciated
Thanks - Barry

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