Sorry if this has been dealth with before.
There seems to be a problem with Sequence Numbers in 4D SQL 11.1.
The number gets bumped up by one even if you make modifications to an existing record. For ex.
Create a Table Customers. Add a couple of fields like ID, Name, Password.
Then create automatic layouts. Create one record with the automatic layout. The ID of this record is 1. Create another record. ID becomes 2. Then cancel the input entry. go back to the first record. Modify the passowrd. And when you create a new record the ID becomes 4. 3 was eaten up for breakfast.
Is this a known issue with the latest 4D or I'm missing something. This behaviour is consistent with all the example databases supplied with 4D SQL 11.1
Any help/explanation very appreciated.
Les
