What better use?
Using SQLite3. How to record in the table?
Mailing lists / lazarus / 2013-02
Append or Insert?
2 messages · 2 people ·
- John 1
- Junior 1
Reply by email Subscribe to this list Your subscription
Read-only archive. Use j and k to move between messages.
Junior wroteWhat better use? Using SQLite3. How to record in the table?
You haven't given us a lot to go on!
If you are inserting or appending into an indexed table, as far as I know it doesn't make any difference. (And ALL sql tables should be indexed). I usually use append. I think on some tables insert attempts to insert a record into the current location, but this doesn't make any sense in sql, and probably isn't possible.
Very basically, using sqldb components, you insert a record, post the insert to the query, apply updates on the query, then commit the transaction. But I will leave detailed descriptions to someone who knows SQLIte - I have always had trouble with it.
There is heaps of information on the wiki, see eg
http://wiki.lazarus.freepascal.org/Databases
hope this helps a bit
John Sunderland