Tech Tip: Resetting the sequence number
PRODUCT: 4D | VERSION: 2004 | PLATFORM: Mac & Win
Published On: November 4, 2005
In previous versions of 4D, the only way to change the sequence number was with some tricky programing and then you could only increase the sequence number. With version 2004, you can reset the sequence number in a table to any legitimate value with a single command. The SET DATABASE PARAMETER command allows you to reset the sequence number of a table in a 4D database. For example SET DATABASE PARAMETER ([table]; 31; 850) would reset the sequence number for table [table] to 850.