You can always SELECT <primary key fields> FROM <table> WHERE ROWID=<returned value>
in case you have forgotten the values of the fields just inserted. Regards Gunter -----Ursprüngliche Nachricht----- Von: Ashok Pitambar [mailto:ashokpitam...@gmail.com] Gesendet: Dienstag, 26. Februar 2013 10:16 An: General Discussion of SQLite Database Betreff: Re: [sqlite] sqlite3 last insert rowid Thanks Hick, Is there any way to primary key(composite key) just after insert using sqlite API? On Tue, Feb 26, 2013 at 1:26 PM, Hick Gunter <h...@scigames.at> wrote: > No. It returns the value of the (hidden) column rowid. > > -----Ursprüngliche Nachricht----- > Von: Ashok Pitambar [mailto:ashokpitam...@gmail.com] > Gesendet: Dienstag, 26. Februar 2013 08:51 > An: sqlite-users@sqlite.org > Betreff: [sqlite] sqlite3 last insert rowid > > Hi All, > > Does function sqlite3_last_insert_rowid returns the composite key if > created with 2 columns? > > Thanks > Regards, > Ashok > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ---------------------------------------------------------------------- > ---- > Gunter Hick > Software Engineer > Scientific Games International GmbH > Klitschgasse 2 - 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. > If you have received it in error, you are on notice as to its status > and accordingly please notify us immediately by reply e-mail and then > delete this message from your system. Please do not copy it or use it > for any purposes, or disclose its contents to any person as to do so > could be a breach of confidence. Thank you for your cooperation. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users