SQLIsNullField

Checks presence of null value in field from a recordset. To get to a specific record in the recordset, use either the SQLNext()/SQLPrev() functions or the nRowIndex argument.

When the hGeneral is the connection handle, the function returns information from the default recordset. When the hGeneral is the recordset handle, the function returns information from the recordset itself.

This function can be called in the foreground or background.

Syntax

SQLIsNullField(hGeneral, sField, nRowIndex=-1)

hGeneral:

The handle either to:

• the DB connection object, returned from either SQLCreate() or SQLConnect() function. The handle identifies the DB connection object where details of the associated SQL connection are stored
• the recordset

sField:

The name of the field or column.

nRowIndex:

The number of the row which data is requested. The first row has index 0. -1 means that an internal pointer is used instead. The pointer can be moved forward and backward by executing SQLNext() or SQLPrev() functions.

Return Value

TRUE if the value is NULL, FALSE otherwise.

Related Functions

SQLSet, SQLAppend, SQLExec, SQLGetRecordset, SQLCall, SQLGetScalar, SQLEnd, SQLNumChange, SQLNoFields, SQLNumFields, SQLFieldInfo, SQLGetField, SQLIsNullField, SQLRowCount, SQLNext, SQLPrev

SQL Functions

Published June 2018