User Tools

Site Tools


sqlite_commands.htm
Navigation:  SQL Drivers > SQLite Accelerator >SQLite Accelerator Supported Commands and Attributes Previous pageReturn to chapter overviewNext page
File Attributes Supported
CREATE Y
DRIVER(filetype [,driver string]) Y
NAME Y
ENCRYPT N
OWNER(password) Y1
RECLAIM N
PRE(prefix) Y
BINDABLE Y
THREAD Y
EXTERNAL(member) Y
DLL([flag]) Y
OEM N
File Structures Supported
INDEX Y
KEY Y
MEMO N
BLOB Y
RECORD Y
Index, Key, Memo Attributes Supported
BINARY Y
DUP Y
NOCASE Y
OPT N
PRIMARY Y
NAME Y
Ascending Components Y
Descending Components Y
Mixed Components Y
Field Attributes Supported
DIM N
OVER Y
NAME Y
File Procedures Supported
BOF(file) N
BUFFER(file) N
BUILD(file) Y
BUILD(key) Y
BUILD(index) Y3
BUILD(index, components) Y3
BUILD(index, components, filter) N
BYTES(file) Y
CLOSE(file) Y
COPY(file, new file) N
CREATE(file) Y7,8
DUPLICATE(file) Y
DUPLICATE(key) Y
EMPTY(file) Y
EOF(file) N
FLUSH(file) N
LOCK(file) N
NAME(label) Y
OPEN(file, access mode) Y6
PACK(file) N
POINTER(file) N
POINTER(key) N
POSITION(file) N
POSITION(key) Y
RECORDS(file) Y
RECORDS(key) Y
REMOVE(file) Y
RENAME(file, new file) N
SEND(file, message) Y
SHARE(file, access mode) Y
STATUS(file) Y
STREAM(file) N
UNLOCK(file) N
Record Access Supported
ADD(file) Y
ADD(file, length) N
APPEND(file) Y
APPEND(file, length) N
DELETE(file) Y
GET(file,key) Y
GET(file, filepointer) N
GET(file, filepointer, length) N
GET(key, keypointer) N
HOLD(file) N
NEXT(file) Y
NOMEMO(file) N
PREVIOUS(file) Y
PUT(file) Y
PUT(file, filepointer) N
PUT(file, filepointer, length) N
RELEASE(file) N
REGET(file,string) N
REGET(key,string) Y
RESET(file,string) N
RESET(key,string) Y
SET(file) Y
SET(file, key) N
SET(file, filepointer) N
SET(key) Y
SET(key, key) Y
SET(key, keypointer) N
SET(key, key, filepointer) N
SKIP(file, count) Y
WATCH(file) Y
Transaction Processing Supported
LOGOUT(timeout, file, …, file) Y2,4,5
COMMIT Y
ROLLBACK Y
Null Data Processing Supported
NULL(field) Y
SETNULL(field) Y
SETNULL(file,field) Y
SETNONNULL(field) Y

Notes

1 The OWNER is the name of the SQLite database file that the table is stored in.
2 See also PROP:Logout in the Language Reference.
3 BUILD(index) sets internal driver flags to guarantee the driver generates the correct ORDER BY clause. The driver does not call the backend server.
4 You cannot logout threaded and non-threaded files at the same time.  All files in the LOGOUT statement must be in the same database table.
5 Doing SET;NEXT;LOGOUT;NEXT is not supported.
6 If OPEN fails with ERRORCODE 47 (InvalidFileErr), and you have file logging turned on (See the 'Database Driver System-wide Logging'), the log file will have the name of the field that could not be found in the table on disk and a list of names of columns in the table on disk.
7 CREATE converts Clarion data types to SQLite Data types using the following table
Clarion Data Type SQLite Data Type
STRING CHAR
CSTRING VARCHAR
STRING(8);GROUP OVER(STRING);DATE;TIME DATETIME
DATE DATE
PDECIMAL NUMBER
DECIMAL NUMBER
BYTE TINYINT
SHORT SMALLINT
LONG INTEGER
SREAL FLOAT
REAL REAL
BLOB CLOB
BLOB,BINARY BLOB
8 A PRIMARY KEY AUTOINCREMENT constraint will be added to a field definition if /AUTOINC=TRUE is specified in the driver string and the field is the key component of the primary key and there is only one key component for the primary key and the field type is LONG.
sqlite_commands.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1