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!
>  :)
> 

Reply via email to