J.M., If you use the autonum column as a synthetic ID number linking to other tables, won't this give you heartburn?
Ben Petersen On 23 Oct 2001, at 16:37, J.M. GRATIAS wrote: > > Carol : > > >> > One of several databases has one table with an autonum column that > sometimes > skips 30 or 40 numbers, apparently overnight. The column definition is 8 > characters, with a format of 00000000 and increment of 1. The current > initial value is 4306. It is a primary key. It is used as a record > number. > We run a packing procedure automatically every night using reload. > Any ideas on what may be happening? > << > > I also do have some problems with AUTOMUN columns. > > So, after every BACKUP, UNLOAD/RELOAD DB, I insert : > > SET rules OFF > AUTONUM ColumnName IN TableName USING 1 NUM > SET rules ON > > If you use rules, don't forget to set RULES OFF. > > If you don't, and if somes rows contains bad data, AUTONUM will stop and > you may have duplicate values in ColumnName ... > > Hope this will help ... > > J.M. GRATIAS, Logimatique, France >
