Re: Getting a serial index back

> [...] > I have a header record with a serial index on it, so after I > insert the header record into table 1, I would like to know what > that serial number is so I can put it in the detail record I > am about to insert into table 2. > [...] I think that SQLERRD[2] has what you want. See the "Informix Guide to SQL Tutorial v7.1" part number 000-7634, page 5-10, and "Informix-4GL Reference: Volume One v6.0" part number 000-7611, page 2-24. I haven't used this, so check it closely. Note also that you can get the rowid this way. Informix recommends that you DON'T use the rowid as a key in your applications. Have fun, __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|