Recent

Author Topic: SQLite documentation  (Read 5845 times)

hulky

  • Newbie
  • Posts: 2
SQLite documentation
« on: May 31, 2005, 08:23:21 pm »
Hi,

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

Wim

Vincent Snijders

  • Administrator
  • Hero Member
  • *
  • Posts: 2661
    • My Lazarus wiki user page
SQLite documentation
« Reply #1 on: June 01, 2005, 02:43:28 am »
See this page on the Lazarus Code and Components Repositry.

hulky

  • Newbie
  • Posts: 2
SQLite documentation
« Reply #2 on: June 01, 2005, 09:55:54 am »
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

  • Newbie
  • Posts: 3
SQLite documentation
« Reply #3 on: July 15, 2005, 05:15:55 pm »
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
Use execute instead of open.

LuizAmérico

  • Sr. Member
  • ****
  • Posts: 458
SQLite documentation
« Reply #4 on: July 16, 2005, 06:36:52 pm »
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....?

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.

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

 

TinyPortal © 2005-2018