Re: Serial ID from PUT

Daniel Wright wrote: > > simply stated > we declared an insert cursor, however we need to know the serial key > assigned to the record we just inserted. > > Since the record is not actually inserted until the close cursor (for > the insert cursr), can we also use SQLCA.SQLERRD[2] for the v;ue of the > serial key > > It seems we can't; is there a way around this, other than INSERTing, w/o > an insert cursor. > danwright@bigfoot.com One possible solution is to FLUSH after the insert. You still loose performance, but you are still using the prepared statement to reduce overhead. -- wilcoxon@pioneerplanet.infi.net ********************************************************************** ... this is only a test ... if this had been a real signature it would have been interesting **********************************************************************