Re: retrieve counter value after insert via ODBC

Stephan Meier wrote: > > How can I retrieve the value of a counter field after an insert statement, > not containing the counter field. > > EG. Table: TEST(id counter, name char(20)) > > insert into TEST (name) values ('Miller'); Is a "counter"-field a "serial" ? If so then try "select id from TEST where id = dbinfo('sqlca.sqlerrd1');" after the insert. Gert. -- Gert Brinkmann email: gbrinkmann@dimedis.de Software Development tel: 0221/921260-0 dimedis GmbH fax: -99 Habsburgerring 2-12 http://www.dimedis.de 50674 Koeln http://www.RealTimeImage.de