Usually I just use autonumber columns and don't worry about missing values (in the event a user deletes a row). Now I need to write an application that consecutively numbers records (no gaps in the sequence). I also have an autonumber field to use as the PK.
My inclination is to handle the numbering in an ON AFERT INSERT trigger, using the NEXT function against a "dummy" autonumber table to get the value. Does anyone have any thoughts or other suggestions on how to handle this task? -- Larry __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
