Re: Record Insert and serial ID question

Nils Myklebust wrote: > select dbinfo('sqlca.sqlerrd1') > from sometable > where condition returning only one row > > The best is to have a table that contains a single row only (we always > have one anyway with some system data) and simply do: > > select dbinfo('sqlca.sqlerrd1') > from thetablewithonlyonerow more simple: if you want the serial-value in "id" from "my_table": select id from my_table where id = dbinfo(...); 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