How to test for NULL values in ADO Recordsets?

jsnayberk · 2010-08-27

I am reading from an external SQL-Sever database and importing into NAV2009 SP1 classical.
I´m doing i.e.

NAVTable.Name2 := ADORecSet.Fields.Item('Name2').Value

Trying to import a NULL-valued field from the ADO recordset into NAV is resulting an error because NAV can´t handle NULLs.
Is there a way to test for NULL values in the recordset fields?
I allready tried to search the forum for solution. I found a posting recommending

IF NOT IsNull(adoRS.Fields.Item(i-1)) THEN BEGIN

doesn´t work because the IsNull-Function is not existing.
Can anybody set me on the right track?

Regards

kriki · 2010-08-27

I use this one:

IF FORMAT(ADORecSet.Fields.Item(ItxtFieldName).ActualSize) = FORMAT(0) THEN // NULL-value
  EXIT('');

jsnayberk · 2010-08-27

Thanks. Works!

How to test for NULL values in ADO Recordsets?

Comments

Categories