delphi sqlite3 控件

******************************* 华软源码：http://www.hur.cn 欢迎转载，但请保留出处，谢谢 ******************************* 27 Aug 2007 Amended TSQLiteDatabase constructor to convert filename to UTF8,for compatibility with latest SQLite3 DLL. Updated DLL to version 3.4.2 (built with MSVC 6.0). 14 Aug 2005 The following changes were made by Lukas Gebauer (geby@volny.cz). In addition, some changes from a previous D5-compatible version were merged, and the supplied sqlite3.dll is updated to version 3.2.2 Notes from Lukas: - added support for delphi 4+ - datatype constants matches SQlite datatypes contants. (otherwise in some situations you got bad column datatype!) - removed dependency on strutils - code is reformated to better look (official borland formationg rules) - added some pragma's after database is open (temp is in memory) - TSQLiteDatabase.GetTableValue(const SQL: string): int64 for easy call of SQL commands what returning one number only. (like select count(*)...) - TSQLiteDatabase.GetTableString(const SQL: string): String for easy call of SQL commands what returning one string only. (like PRAGMA integrity_check) - TSQLiteDatabase.SetTimeout(Value: integer); you can set timeout for accessing to some table. Good for database sharing! - TSQLiteDatabase.version: string; returns SQLITE version string - removed bool fieldtype (it is not natural SQLite3 type) - fild type detection by Sqite3_columnType knows REAL too. - integer filedtype is based on Int64 - GetFields can get data from any supported fieldtype - changed some integers to cardinal for avoid signed and unsigned mismatch - TSqliteTable.FieldAsInteger(I: cardinal): int64; returns int64 3 May 2005 Fixed bug where strupper called on column type before checking for nil 2 May 2005 Add extra check for nil in TSqliteTable.Destroy, thanks to Tim Maddrell 22 Apr 2005 Revise TSqliteTable.Destroy to fix memory leak with dtStr type (thanks to Jose Brito) 21 Apr 2005 Quick revision to fix case sensitivity in detecting column type, and remove PRAGMA full_column_names = 1 which is deprecated. Warning: may break code. Fix your SQL code so that all column names in a result set are unique. 21 Feb 2005 Sqlite DLL now 3.1.3 19 Feb 2005 Revised for Sqlite 3.1.2 21 Dec 2004 First public release The following notice appears in the Sqlite source code: * ** 2001 September 15 ** ** ** The author disclaims copyright to this source code. In place of ** a legal notice, here is a blessing: ** May you do good and not evil. ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. For more information about SQLite, see http://www.sqlite.org For more information about this simple wrapper, see http://www.itwriting.com/sqlitesimple.php