Re: Getting Serial Value

Daniel Wright <dw420@airmail.net> wrote: :Also, if you are using an insert cursor, forget about getting your :serial value. :This is due to the fact that insert cursors only actually insert into :the database, when 1) they are closed, 2) they fill up their buffer and :must be flushed, or 3) you explicitly flush them. We use insert cursors in this case all the time. We do an explicit flush before we read the serial number from the sqlca record. We have found that even with an explisit flush for every row inserted, the insert cursor is faster than any other method for inserting rows in a program. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org