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()