Re: How to get value of serial column from PB5.0?

On 12 May 97 at 21:30, Grace Wu wrote: > I have serial column on some tables, and my problem is I couldn't get the > serial value from PB after each inserted row. PB 5.0 has a 'identity > column' feature, which supposedly should bring back the new serial value > from Informix to PB. However, I don't know how to get the value. I had OK, I *assume* you're using a Stored Procedure to do the insert. If this is the case, you can get the serial value in DBINFO("sqlca.sqlerrd1") <I think!> and then return that to yourprogram. HTH. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Kuwait City Help fight crime in South Africa: http://www.robkaplan.org.za/