dbQuerySeekFirst

Purpose

Retrieves the first record in the result, if available, and positions the query on the retrieved record.

Format

ret = dbQuerySeekFirst(qid)
Parameters:qid (scalar) – query number.
Returns:ret (scalar) – 1 if successful. If unsuccessful the query position is set to an invalid position and 0 is returned.

Examples

// Create and prepare query
qid = dbCreateQuery(db_id, "SELECT *
    FROM PEOPLE");

do while dbQuerySeekNext(qid);
    // iterate over results
endo;

// set back to start
dbQuerySeekFirst(qid);

do while dbQuerySeekNext(qid);
    // iterate over results AGAIN
endo;

Remarks

Note that the result must be in the active state or it will do nothing and return. This can be verified by calling the dbQueryIsSelect() function.