mORMot Open Source

KJames

Member

Registered: 2013-07-02

Posts: 15

Getting ID from Batch Insert

I need to use a Batch Insert method (there are a lot of records), but after the insertion in the database,  I need to get all the IDs of the inserted records.
How can I do that?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Getting ID from Batch Insert

Use BatchStart
  + BatchAdd() in a loop
  + BatchSend() which returns the IDs in its parameter variable.

See http://blog.synopse.info/post/2011/06/0 … ng-records
and the latest revsion 1.18 Of the SAD pdf.

Do not forget to use a transaction for SQlite3.

KJames

Member

Registered: 2013-07-02

Posts: 15

Re: Getting ID from Batch Insert

Once again you are right and helped me to solve my doubt.

Thank you very much!!!