Hi Listmembers, I would like to know, how I can get the information what Number a new added column got assigned?
For example: CREATE TABLE ssrm.customers ( customerid FIXED(10) DEFAULT SERIAL PRIMARY KEY, customername CHAR(40)) INSERT INTO srm.customers (customername) VALUES ('Wattweissich') Now I am looking for a solution, to inform the user on the backend (an VB.Net-App via ODBC) about the customerid the new added customer get? I read something in the reference about 'CURRVAL' - but unfortunately I did not see how I can use that for my purposes. Maybe someone here can give me a hint? Thanks for help & comments! Regards Andreas -- GMX DSL = Maximale Leistung zum minimalen Preis! 2000 MB nur 2,99, Flatrate ab 4,99 Euro/Monat: http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]