Re: [gnome-db] How to retrive last auto_key value after INSERT INTO Statement ?

[Rodrigo Moya <rodrigo gnome-db org>]

On Mon, 2003-06-09 at 14:31, Morpheus Orein wrote:
> Hello !
> 
> Your previous feedback was very helpfull ...thanx..
> 
> I am now using libGda with RedHat Linux 8.0 + Apache 2.0.
> My Application runs as a CGI created with Cgicc.
> 
> All of thease technologies works great ....
> 
> I have a question though ... (maby last one !)
> 
> is there any way i can retrive last inserted value from libGda ?
> 
> If i execute :  "INSERT INTO ..." statement , and now i want the last 
> inserted (auto_key) value from that table ...
> 
> example:
> 
> Products  Table has  Product_ID field as  auto_key(auto_increment)  value..
> now , whenever i insert a row into Products table , there will be new 
> Product_ID ...
> 
> is there any direct way to retrive that Product_ID (without a SQL statement 
> ?)
> 
no, there isn't, but if you add a wishlist to bugzilla
(http://bugzilla.gnome.org), we'll implement it, since it is quite easy
to do so, at least for some providers.

cheers