Re: Stored Procedures and SQLCA record access

Peter J Diaz de Leon <peter@alumni.cs.uwm.edu> wrote in article <5ac24e$p8u@uwm.edu>... > > > > - create a procedure (parameter integer) which sets value > > into global variable > > - create a "insert" trigger on the table > > - in this trigger you can obtain new.serial_column > > - execute this procedure in the trigger > > - now you have your serial value in the global variable > > > >HTH, > >Pepa > > > > Pepa > > I follow you almost. Once the global variable is assigned > the serial value, how do I return it to the calling 4GL > program. Please let me explain my confusion. > Write another procedure to return global variable. (this was the reason to assigning a serial value into a global variable in a trigger) -- HTH, Pepa