Re: Help!, how to find serial id. after insert in Powerbuilder?

Mancunian1@aol.com wrote: : We're using Powerbuilder 4.0 and Online 7.1 : Is there any way to find out the serial id. after an insert from : Powerbuilder? Do the insert with a stored procedure. If you are running DSA 6.0 or greater, the dbinfo("sqlca.sqlerrd[2]") function call will return the serial value. If you are running OnLine 5.01 or greater you can use a trigger to pass the inserted serial value to a second procedure. Assign the passed-in value to a global variable in the second procedure; the procedure performing the insert will be able to access that global variable. : In 4GL it is,as you know, sqlca.sqlerrd[2] : Thanking you in anticipation of a solution ! -- ___ ___ Senior Consultant / ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210 _/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111 dberg@informix.com Opinions expressed herein are my own. Eventually all things merge into one, and a river runs through it. -N.Maclean