Using the %dbqueryrawresult, %dbqueryrows, and %dbqueryvariables Variables

When using an SQLite database, the %dbqueryrows variable contains the number of rows resulting from a SQL query submitted by the DBQUERY script command. A maximum of 1000 rows is allowed on any single query before an error occurs. This value is not set when using an ODBC data source.

The %dbqueryvariables variable contains the number of individual %db_xxxx variables created by the DBGETRESULTS command when parsing the result of a single SQL query submitted by the DBQUERY script command.

When using an SQLite database, the %dbqueryrawresult variable contains a raw text string resulting from a SQL query submitted by the DBQUERY that cannot be parsed into individual %db_xxxx variables by a subsequent DBGETRESULTS command. Normally this variable is reserved for debugging purposes and is only assigned in the event of an error during the execution of DBGETRESULTS. This value is not set when using an ODBC data source.

See also: Internal Script Variables, Using the built-in database engine