isnullcolumn

Determine if last record read in resultset is NULL

Syntax

a = isnullcolumn(rset)

Description

a = isnullcolumn(rset) returns 1 if the last record read in the resultset rset is NULL. It returns 0 otherwise.

Examples

Example 1 — Result Is Not NULL

isnullcolumn returns not null.

  1. Run:

    curs = fetch(curs,1);
    rset = resultset(curs);
    isnullcolumn(rset)
    ans =
         0
    
  2. Verify this result.

    curs.Data
    ans = 
        [1400]
    

Example 2 — Result Is NULL

isnullcolumn returns null.

  1. Run:

    curs = fetch(curs,1);
    rset = resultset(curs);
    isnullcolumn(rset)
    ans =
         1
    
  2. Verify this result.

    curs.Data
    ans = 
        [NaN]
    

See Also

|

Was this topic helpful?