dbQueryIsValid#

Purpose#

Reports whether the specified query is positioned on a valid record.

Format#

ret = dbQueryIsValid(qid)#
Parameters:

qid (scalar) – query number.

Returns:

ret (scalar) – 1 if the query is positioned on a valid record or 0 otherwise.

Examples#

// Execute query
qid = dbExecQuery(db_id, "SELECT * FROM
     PEOPLE");

// Check if query is valid
dbQueryIsValid(qid); // False

// Give it a valid position
dbQuerySeekFirst(qid);

// Iterate until no longer valid.
do while dbQueryIsValid(qid);
    // dbQueryIsValid = True
    dbQuerySeekNext(qid);
endo;

dbQueryIsValid(qid); // False