Arbeiten mit SQLite

[aducom]

Sorry, but being Dutch, I'm quite able to read, speak and listen to German, but writing is a different story.

The SQLite components with TDataSource work quite similar to the ones used with the BDE, although the BDE is NOT used. To use TAsqliteTable you need to set a filter to be able toselect on your dataset and next a locate can be used to search within the result set.

Why the prior statement? On open the first row is selected and presented. To search the first record you could apply .first().

Generally a basic application should look like this:

Put a TASQLiteDB componentn on your for, select the appropiate dll, the database main directory and database.
Put a TASQLiteTable component on your form and select the TASQLiteDB on the connection property. Select the wanted table.
Put a TDataSource on the form and connect to the TASQLiteTable
Put a DBGrid on the form and connect to the datasource.
Open the table.

Just as you would build a BDE application isn't it/

With the TASQLiteQuery you can apply your sql yourself.

Creating all the components on runtime, well this is possible (of course) but why not apply the components to the form?

If any questions left you can register through the support forum.

Delphi/C++ Freeware SQLite components

Albert Drent
aducom software support group.