FetchRow - Maple Help
For the best experience, we recommend viewing online help using Google Chrome or Microsoft Edge.

Online Help

Database[SQLite]

  

FetchRow

  

fetch row from a prepared SQL statement

 

Calling Sequence

Parameters

Options

Description

Examples

Compatibility

Calling Sequence

FetchRow( statement, opts )

Parameters

statement

-

prepared SQL statement obtained using the Prepare command

Options

• 

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".

Description

• 

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.

Examples

Select all data from table - prepare statement

(1)

Fetch the first row

(2)

Fetch the second row, but change the valuetype to "integer" for the first column and "text" for the second

(3)

Select all data row by row

(4)

(5)

Compatibility

• 

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