aboutsummaryrefslogtreecommitdiffstats
path: root/songmanagement/src/lib/SQLite/readme.txt
blob: 7998d17f44845a7fbf314cfa0e61be385c6a7f94 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
5 June 2008
Updated DLL to version 3.5.9 (built with MSVC 6.0)
Added code from Andrew Retmanski to support prepared queries (see comments in SQLIteTable3.pas
Lukas added support for named parameters - see comments in code
User nebula enhanced error message; also modified code to call sqlite3_reset before checking error message


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 reformatted to better look (official borland formatting 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