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]

Reply via email to