1
1
This is the Database directory of the Free Component Library.
3
At the moment, there is a read/write implementation of TDataset.
4
The blob support is not tested yet.
8
Just run 'make all' and all should go fine, provided
9
1) The mysql unit is in the compiler path (the makefile will try to compile
10
it in the packages mysql subdirectory)
11
2) the mysqlclient library is in /usr/lib (if you want to compile the mtest
13
if these conditions are not satisfied, you should edit the makefile
14
and add -Fl/path/to/libmysqlclient to NEEDOPTS as well as
15
the -Fu/path/to/mysql/unit option.
17
Compiling the examples:
19
If the units compile fine, then the examples can be compiled by doing
20
'make examples'. see also the above remarks.
22
there are 2 descendents of TDataset to demonstrate/test the
23
TDataset implementation.
27
Implemented in ddg_ds and ddg_rec. The dataset as
28
implemented in the Delphi 4 Developers Guide.
33
the first creates a flat file, filled with 100 records;
34
the second tests the navigation methods of TDataset on this file.
35
the third tests the editing methods of TDataset (Append,Insert
39
Implemented in mysqldb. You need the mysql units for this.
40
This is a temporary implementation based on the code from
41
Rangel Gustavo Reale (hitnrun@geocities.com)
42
it will be used as a base for the DBdataset scalable dataset
46
this will run the query SQL on the database db with user
47
'user' and password 'pwd', and dump the result. Take care
48
that you don't specify blob fields.
49
To test it on the table created by the mkdb shell script
50
that comes with the Free Pascal mysql unit, I did a
51
mtest test michael pwd 'select * from FPdev'
53
I haven't implemented/tested blob fields yet.
3
All base classes are in the db unit, the dbconst unit contains the
7
contains a dataset-class in memory which can be read from, and
11
contains a framework to work with several SQL-based databases
12
as Interbase, Firebird, MySQL, ODBC and Oracle
15
contains the tDbf components, to work with DBASE and FoxPro
19
contains a dataset class to use text files directly as a
20
database. That could be fixed-size, or limited (SDF)
23
contains datases classes to use sqlite and sqlite3
26
contains some obsolete units which were replaced by better
27
alternatives, or which are old tests which are not needed