SQLite documentation

[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]

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

Use execute instead of open.

[LuizAmérico]

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....?

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

A (reference to) a sample would be greatly appreciated.

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