dbQueryFetchOneSA

Purpose

Returns a single row as a string vector containing the field information for the current query.

Format

record = dbQueryFetchOneSA(qid[, columns])
Parameters:
  • qid (scalar) – query number.
  • columns (string or string array) – Optional input. Gives specific columns to pull from the result matrix. Must be a subset of fields from the SELECT statement.
Returns:

record (string array) – if the query points to a valid row (dbQueryIsValid() returns true), the record is populated with the row’s values. An empty record (scalmiss(record) is true) is returned when there is no active query dbQueryIsActive() returns false).

Examples

// Execute `qid` query
qid = dbExecQuery(db_id, "SELECT COUNTRY,
    TOTAL FROM GDP");

/*
** Iteratively retrieve single records
** and store as string
*/
do while dbQuerySeekNext(qid);
    record = dbQueryFetchOneSA(qid);
    country = record[1];
    total = record[2];
endo;

Remarks

This function is only useful in an iterative context. You can easily retrieve all the results at once by using the dbQueryFetchAllM() and dbQueryFetchAllSA() functions.

For numerical only results, using dbQueryFetchOneM() will return a matrix instead of a string array.