Simple SQLite Client

 

Simple SQLite client using libsqlite3.

miyako/4d-plugin-simple-sqlite-client

status:=status:=SQLite EXECUTE (path;SQL{;params{;mode}})
Parameter
Type
Description
path
TEXT
SQL
TEXT
params
COLLECTION
mode
LONGINT

SQLite Integer Format

Property Type Description
SQLite Integer Simple LONGINT 0
SQLite Integer Complex LONGINT 1

If SQLite Integer Simple is passed, columns of type SQLITE_INTEGER are returned as int.

If SQLite Integer Complex is passed, columns of type SQLITE_INTEGER are returned as objects, where each item has two properties: intValue which is int and int64Value which is text.