[Lazarus] Append or Insert?

John jszcmpr at netspace.net.au
Wed Feb 20 13:11:40 CET 2013


On 02/20/2013 09:21 PM, Junior wrote:
> What 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




More information about the Lazarus mailing list