dbQueryIsNull

Purpose

Returns 1 if the query is active, positioned on a valid record and the field is NULL; otherwise returns 0.

Reports whether the current field pointed at by an active query positioned on a valid record is NULL.

Format

ret = dbQueryIsNull(qid, field)

Parameters:

• qid (scalar) – query number.

• field (scalar) – index into result set.

Returns:

ret (scalar) – 1 if the field is NULL or 0 otherwise.

Remarks

Note that for some drivers, dbQueryIsNull() will not return accurate information until after an attempt is made to retrieve data.

See also

Functions dbQueryIsActive(), dbQueryIsValid()