Re: Getting value of serial column after insert inside stored procedure, help!

This is how I do it: I have a trigger on the insert. The trigger calls a procedure and passes as an argument the serial number just inserted. The procedure stores the serial number in a global variable The global variable is then accessible from any other procedure. I may have a twisted mind, but it works. I have not find anything simpler. Bashar Chalabi Card Tech Ltd > vsp@triada.triad.com (Vaishali Padhye) writes: > Hi, > > I am inserting a record in a stored procedure for a table having > a serial column, now I want to find out the value the serial > column got assigned and return it. > > I know it gets assigned in sqlca.sqlerrd[1], but thats useful in > 4gl or esql program, can this structure be accessed in a stored > procedure? Any pointers will be a great help. Thanks! > > Vaishali Padhye > Triad Systems Corp. > > #include <std_disclaimer.h> > > >