> > the last inserted id in the table like we do with MySQL using the
> > GetLastInsertID ?
> >
> > My need is to get back the new id just after inserting.
>
> Use currval() after you have inserted.
That will not necessarily tell you the last insertion, depending
upon how many other users there are doing inserts.
For that matter, I'm not sure that the MySQL method works with multiple
users either.
--
Mike Nolan