SQL and serial columns

Posted in 1998

Surfer — Thu, 1 Oct 1998 13:22:25 +0100 — source: Informix-list mailing list archive (1991-1998)

Using SQL (6.05) (not ESQL or 4GL) is there anyway other than select max( mycol ) from mytab to find the value of a serial number just created by insert into mytab values( 0 ) It would be most helpful if there is. Thank you. -- Surfer! http://www.nevis-vieww.demon.co.uk http://www.nevis-vieww.demon.co.uk/flash Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.