Database Toolbox™

isnullcolumn - Detect whether 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

get, resultset

isjdbc

isreadonly