Data Retrieval on SQLite

The offset option, order by, and where clauses of the read ProcScript statement are supported.

Stepped Hitlists

The stepped hitlist mechanism is supported. However, because SQLite has poor support for concurrent access, it is disabled by default. This can be overruled using the step size connector option.

For more information, see Locking Considerations for SQLite and step size.

read

The following clauses of the read ProcScript statement are supported:

  • offset option for data —fully supported.

  • where clause—fully supported. All text between the double quotation marks (") is inserted into the generated select statement literally as entered.

    order by—fully supported. To guarantee that a specific order is returned, use the read order by ProcScript statement.

For more information, see read .

selectdb

The order by clause is not supported in the selectdb ProcScript statement.

The table shows the SQLite fields that have restrictions imposed while using the selectdb statement:

SQLite Fields and Restrictions When Using selectdb

SQLite Field

Max

Min

Sum

ave

count

BLOB

Yes

Yes

No

No

Yes

TEXT

Yes

Yes

No

No

Yes

INTEGER

Yes

Yes

Yes

Yes

Yes

REAL

Yes

Yes

Yes

Yes

Yes

Related Topics