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
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Josef Snayberk