sqlite_stepT_sqlite_stepSqliteStepSqliteStep (Operator)

Name

sqlite_stepT_sqlite_stepSqliteStepSqliteStep — Returns the next row of the results of a previous SQL statement.

Signature

sqlite_step( : : SqliteHandle : ResultColumns, IsEnd)

Description

sqlite_opensqlite_openSqliteOpenSqliteOpenSqliteOpen returns the next row of the results of an SQL statement that was previously executed using sqlite_execsqlite_execSqliteExecSqliteExecSqliteExec.

SQLITE_INTEGER are returned as HALCON tuple integer. SQLITE_FLOAT are returned as HALCON tuple reals/doubles. SQLITE_TEXT are returned as HALCON tuple strings. SQLITE_NULL are returned as special HALCON tuple string "{{NULL}}". SQLITE_BLOB are returned as special HALCON tuple string "{{BLOB}}". Unknown data types are returned as special HALCON tuple string "{{???}}".

Find more information about the Sqlite extension package in the introduction to this chapter.

Execution Information

Multithreading type: reentrant (runs in parallel with non-exclusive operators).
Multithreading scope: global (may be called from any thread).
Processed without parallelization.

Parameters

SqliteHandleSqliteHandleSqliteHandleSqliteHandlesqliteHandle (input_control) framegrabber → (handle)

handle to a SQLite data base

ResultColumnsResultColumnsResultColumnsResultColumnsresultColumns (output_control) integer(-array) → (integer / real / string)

all columns of a single result row

IsEndIsEndIsEndIsEndisEnd (output_control) integer → (integer)

true if no more result rows are available

Example (HDevelop)

sqlite_exec (SqliteHandle, 'SELECT rowid, timestamp FROM \'results\';', [])
repeat
  sqlite_step (SqliteHandle, ResultColumns, IsEnd)
  * ...
until (IsEnd)

Module

Foundation

Operators