Release Notes for the GM - SQLite ODBC Driver
- Fast, stable native code (build with freePascal).
- Thread safe. All objects inside the driver are internally secured by critical sections, so they can safely accessed by multiple threads.
- Conforms to ODBC standard 3.5.
- Unicode: The internal string type of the driver is Unicode (Utf-16). It exports only the
SQLXxxxxW
functions. But it converts
string data to ANSI
if an application wants character data as SQL_C_CHAR
(instead of SQL_C_WCHAR
).
- Support for
Date
, Time
and Datetime
datatypes.
- All important SQLite flags can be specified in the Connection strings.
- Easy to use dialog to create or change ODBC data source entries in the ODBC management of the system.
- Supports
SQLSetPos
with operations SQL_ADD
, SQL_UPDATE
, SQL_DELETE
and SQL_REFRESH
for tables with
primary keys, when all primary key columns are in the select list of the statement.
- Automatic data type conversions for almost all possible type combinations: application buffer datatype <=> database column datatype.
- SQLite DLL's included in the installer.