Database[SQLite]
FetchRow
fetch row from a prepared SQL statement
Calling Sequence
Parameters
Options
Description
Examples
Compatibility
FetchRow( statement, opts )
statement
-
prepared SQL statement obtained using the Prepare command
valuetype = string or list(string)
The valuetype option specifies the type of the value. It may be one of the strings "auto", "blob", "float", "integer", "text", or a list of those strings. If a list, then the type of a column is specified by the corresponding element in the list; if a string, then it specifies the type of all columns. See the Database[SQLite] help page for more information about type conversion between SQLite and Maple. The default is "auto".
The FetchRow command returns the values of all columns of the current row of a prepared SQL statement.
In order to fetch the next row, call the Step command while it returns RESULT_ROW.
Select all data from table - prepare statement
Fetch the first row
Fetch the second row, but change the valuetype to "integer" for the first column and "text" for the second
Select all data row by row
The Database[SQLite][FetchRow] command was introduced in Maple 18.
For more information on Maple 18 changes, see Updates in Maple 18.
See Also
Database[SQLite][Finalize]
Database[SQLite][Prepare]
Database[SQLite][Step]
Download Help Document