Options

How to test for NULL values in ADO Recordsets?

jsnayberkjsnayberk Member Posts: 58
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
--
Josef Snayberk

Comments

  • Options
    krikikriki Member, Moderator Posts: 9,098
    I use this one:
    IF FORMAT(ADORecSet.Fields.Item(ItxtFieldName).ActualSize) = FORMAT(0) THEN // NULL-value
      EXIT('');
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    jsnayberkjsnayberk Member Posts: 58
    Thanks. Works!
    --
    Josef Snayberk
Sign In or Register to comment.