Null values checking

rbuser

I am having trouble determining if a field has a null value.

I tried doing this - if pipeEmployeeList['Date'] <> null then Value := 'not
specified' else 'OK'; but I get 'OK' result even though the record has null
value.

Thank you,

Peter

nardmoseley

----------------------------------------------
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');

--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com

--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

That's it! Thank you, I could not find anything about this in the RB help.