Andreas Goldstein wrote:
> 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?
>
>
Select ssrm.customers.currval into :customerid from dual
See
http://dev.mysql.com/doc/maxdb/en/1b/2e97e1b42a11d2a97100a0c9449261/fram
eset.htm
Elke
SAP Labs Berlin
> 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]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
