| **Navigation:**  SQL Drivers > [[sqlite driver.htm|SQLite Accelerator]] >SQLite Accelerator Supported Commands and Attributes | [[sqlite driver.htm|{{btn_prev_n.gif|Previous page}}]][[sqlite driver.htm|{{btn_home_n.gif|Return to chapter overview}}]][[sqlite driver strings.htm|{{btn_next_n.gif|Next 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. |