| Please change your bookmark to the actual Aducom SQLite website. This site is no longer be maintained, the available downloads here are old and also not maintained. You will be redirected to www.aducom.com |
|
Welcome to the Delphi/BCC SQLITE open source components website
|
|
Welcome on the development site of the
SQLite
Delphi Components. Currently we have two versions of the components, one for sqlite version 2.8.x and one for sqlite version 3.0.x. Everybody who are currently using
SQLite with the Borland development environments
Delphi and C++ are encouraged to use these
components and report enhancement requests,
bugs etc. to us through the webforum. These
components are free for any purpose, including
commercial (on your own risk!). The download is a source distribution.
The components work like the components you are used to: TDatabase, TQuery, TTable etc. They do NOT require the BDE, but they require that you have the DB VCL. This means that the components will not work with the standard editions of Delphi and Borland C++ Builder.
|
|
SQLite 3.0 components
|
|
|
The current relase contains support for clobs, blobs and calculated fields; and static linking, and is currently full under continuous development.
|
|
SQLite 2.0 components
|
|
|
These components are only maintained (on bugfixes), but no new functionality will be added. It's here for those of you who are still not using SQLite3.0.
|
|
What is it?
|
|
It's a Delphi Package and has been developed
in Delphi 6 and downgraded to Delphi 4 and
5, and contains the following components:
- TASQLiteDatabase
- TASQLiteQuery
- TASQLiteTable
- TASQLitePragma
- TASQLiteUpdateSQL
- TASQLiteLog
These components are designed as look-alikes
from the TDatabase, TQuery and TTable components
you are used to in Delphi/C++. So using
them shouldn't be much trouble, although
we have not yet the full functionality here.
We expect these
components to run under other Delphi
versions and Borland-C++ too. Please
report any problems/success through
the forum to us.
|
|
|
|
What does it do (sample
code) (Up-to-date property documentation is in the download package)
|
|
TASQLiteDatabase (documentation
of properties)
|
|
|
|
TASQLiteTable (documentation
of properties)
|
Gives full access to a SQLiteTable.
You are able to use it in a typeless
mode and in a typed mode. In typeless
mode you are able to access all
fields as character, since SQLite
is typeless. (You can put a string
into an integer field). In typed
mode the system will check for type
compatibility. This component is
full data-aware and is able to update
your tables using all Delphi data-aware
components
|
|
TASQLiteQuery (documentation
of properties)
|
Gives full access to a SQLiteDatabase.
It supports the standard SQL and
returns the query data from select
statements as a read-only result
set. Of course you can execute all
SQL here, including updates. It
has the same features as described
above.
|
|
TASQLiteUpdateSQL (documentation
of properties)
|
|
|
|
TASQLitePragma (documentation
of properties)
|
This component enables you to alter
the SQLite database standard behaviour.
See for more information www.sqlite.org
-> SQL
|
|
TASQLiteLog (documentation
of properties)
|
|
|
