KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Resetting the sequence number
PRODUCT: 4D | VERSION: 2004 | PLATFORM: Mac & Win
Published On: November 4, 2005
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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.