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.