Isn't it easier to just call: sqlite3_last_insert_rowid()? Olaf
----- Original Message ----- From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, July 24, 2006 5:17 PM Subject: Re: [sqlite] Getting callback with an INSERT > On 7/24/06, Dennis Cote <[EMAIL PROTECTED]> wrote: > > > > You can do this by adding an insert trigger to your table and > > registering a user function that will call back to your code. > > > > create trigger t_in after insert on t > > begin > > select do_insert_callback(new.rowid); > > end; > > > > You will have to write and register the user defined function > > Nifty trick Dennis! > :) >