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