FetchRow - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : SQLite : Database/SQLite/FetchRow

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

withDatabaseSQLite:

dbFileToolsJoinPathkerneloptsdatadir,SQLite,G20-Population.db:

connectionOpendb:

Select all data from table - prepare statement

stmtPrepareconnection,SELECT date, CAN FROM population LIMIT 2

stmtSQLite statement,SELECT date, CAN FROM population LIMIT 2

(1)

Stepstmt:

Fetch the first row

FetchRowstmt

1960-12-31,1.7909009×107

(2)

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

Stepstmt:

FetchRowstmt,valuetype=integer,text

1961,18271000.0

(3)

Finalizestmt:

Select all data row by row

stmtPrepareconnection,SELECT date, CAN FROM population LIMIT 10

stmtSQLite statement,SELECT date, CAN FROM population LIMIT 10

(4)

whileStepstmt=RESULT_ROWdoprintFetchRowstmt,valuetype=integerenddo

1960,17909009

1961,18271000

1962,18614000

1963,18964000

1964,19325000

1965,19678000

1966,20048000

1967,20412000

1968,20744000

1969,21028000

(5)

Finalizestmt:

Closeconnection:

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]