Re: Stored Procedure equiv to esql sqlerrd[1]

Robert J. Cline (rcline@gtetel.com) wrote: : Does anyone know of a informix variable name in Stored Procedures : that is the equiv to esql's sqlca.sqlerrd[1]. I need a stored : to return back to a trigger the serial value after an insert that : was performed in the stored procedure. We had possibly similar problem (although we didn't need the result in a trigger) and got around it by creating an insert trigger on the table with the serial column which executed a S.P. that stored the serial value passed to it by the trigger's "new record" as a global value that was picked up elsewhere. ---------------------------------------------------------------- Peter C. Springall MU Systems UNIX / C / INFORMIX SOLUTIONS peter@musys.mpx.com.au Everything is possible except skiing through a revolving door ----------------------------------------------------------------