SQLite documentation
lazarus / 16-Databases

----------------------------------------------------------------------
hulky · 2005-05-31 18:23

Hi,

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

Wim

----------------------------------------------------------------------
Vincent Snijders · 2005-06-01 00:43

See this page on the Lazarus Code and Components Repositry.

----------------------------------------------------------------------
hulky · 2005-06-01 07:55

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 · 2005-07-15 15:15

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.

WimUse execute instead of open.

----------------------------------------------------------------------
LuizAmérico · 2005-07-16 16:36

QuoteThanks 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

QuoteA (reference to) a sample would be greatly appreciated.
See examples in [fpcsourcedir]\fcl\db\sqlite