The Step command evaluates a prepared SQL statement.

Possible return values are

RESULT_BUSY means that the database engine was unable to acquire the database locks it needs to do its job. If the statement is a COMMIT or occurs outside of an explicit transaction, then you can retry the statement. If the statement is not a COMMIT and occurs within an explicit transaction then you should rollback the transaction before continuing.

RESULT_DONE means that the statement has finished executing successfully. Step should not be called again on this prepared statement without first calling Reset to reset the statement back to its initial state.

RESULT_ROW is returned each time a new row of data is ready for processing. The values may be accessed using the Fetch or FetchRow commands. Call Step again to retrieve the next row of data.

$\mathrm{with}\left(\mathrm{Database}\left[\mathrm{SQLite}\right]\right)\:$

$\mathrm{db}≔\mathrm{Open}\left('':memory:''\right)\:$

$\mathrm{Execute}\left(\mathrm{db}\,''CREATE\; TABLE\; test\; (val1)''\right)$

$\mathrm{stmt}≔\mathrm{Prepare}\left(\mathrm{db}\,''INSERT\; INTO\; test\; VALUES\; (\text{'}row1\text{'}),\; (\text{'}row2\text{'}),\; (\text{'}row3\text{'})''\right)$

$\mathrm{stmt}≔''SQLite\; statement'',''INSERT\; INTO\; test\; VALUES\; (\text{'}row1\text{'}),\; (\text{'}row2\text{'}),\; (\text{'}row3\text{'})''$

$\mathrm{Step}\left(\mathrm{stmt}\right)\:$

$\mathrm{Finalize}\left(\mathrm{stmt}\right)\:$

$\mathrm{stmt}≔\mathrm{Prepare}\left(\mathrm{db}\,''SELECT\; *\; FROM\; test''\right)$

$\mathrm{stmt}≔''SQLite\; statement'',''SELECT\; *\; FROM\; test''$

$\mathrm{Step}\left(\mathrm{stmt}\right)\:$

$\mathrm{Fetch}\left(\mathrm{stmt}\,0\right)$

$''row1''$

$\mathrm{Step}\left(\mathrm{stmt}\right)\:$

$\mathrm{Fetch}\left(\mathrm{stmt}\,0\right)$

$''row2''$

$\mathrm{Step}\left(\mathrm{stmt}\right)\:$

$\mathrm{Fetch}\left(\mathrm{stmt}\,0\right)$

$''row3''$

$\mathrm{Finalize}\left(\mathrm{stmt}\right)\:$

$\mathrm{Close}\left(\mathrm{db}\right)\:$

The Database[SQLite][Step] command was introduced in Maple 18.

For more information on Maple 18 changes, see Updates in Maple 18.