Forum > Databases

SQLite documentation

(1/1)

hulky:
Hi,

Can anyone tell me where I can find the documentation about the TSqliteDataset methods?

Wim

Vincent Snijders:
See this page on the Lazarus Code and Components Repositry.

hulky:
Thanks for the reply. I had seen the page you are referring to but somehow it is not completely clear to me how to retreive data from the database: I set SQL to the required query, call the open method, and then....?
A (reference to) a sample would be greatly appreciated.

Wim

jdtiede:

--- Quote from: "hulky" ---Thanks for the reply. I had seen the page you are referring to but somehow it is not completely clear to me how to retreive data from the database: I set SQL to the required query, call the open method, and then....?
A (reference to) a sample would be greatly appreciated.

Wim
--- End quote ---
Use execute instead of open.

LuizAmérico:

--- Quote ---Thanks for the reply. I had seen the page you are referring to but somehow it is not completely clear to me how to retreive data from the database: I set SQL to the required query, call the open method, and then....?

--- End quote ---

And then the dataset wil be populated with the data and you can browse with First,Next,Pirior methods just like any TDataset


--- Quote ---A (reference to) a sample would be greatly appreciated.
--- End quote ---

See examples in [fpcsourcedir]\fcl\db\sqlite

Navigation

[0] Message Index