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



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 ?)


Thanks in advance ...

_________________________________________________________________
Hotmail is now available on Australian mobile phones. Go to http://ninemsn.com.au/mobilecentral/signup.asp




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]