Simple SQLite client based on the tutorial from sqlitetutorial.net.
miyako/4d-plugin-simple-sqlite-client
status:=SQLite EXECUTE (path;sql{;values{;format}})
Parameter
Type
Description
path
TEXT
path for sqlite3_open
sql
TEXT
command for sqlite3_prepare_v2
values
COLLECTION
values for sqlite3_bind_(text|double|int|null)
format
LONGINT
see below
status
OBJECT
- Blob is returned as base64 text
- Null is returned as null
- Float is returned as double
- Text is returned as text
- Other types are ignored
- Blob binding is not supported (result only)
- Integer64 binding is not supported(result only)
Integer Format
| Property | Type | Description |
|---|---|---|
| SQLite Integer Simple | LONGINT | 0 |
| SQLite Integer Complex | LONGINT | 1 |
In complex mode, the value is returned as an object with 2 properties: intValue int64Value (text)
In simple mode, the value is returned as integer.
PREVIOUSGD v3