Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
In fact, you cannot create an "auto-counter" field as in mySQL for example. You will have to handle that field writing code. I suggest you create a new dialog program to handle this, so that you can also handle the delete and the insert functions etc.
Disadvantage of changing the generated maintenance is that if anyone adds fields to the table or makes other changes in future and re-generates the maintenance dialog, then your changes will be wiped.
Events in the generated mantenance do not get over-written when you re-generate and are thus a bit safer. (Menu path Environment->Modification->Events when in table maintenance generator screen - documentation in help is quite good).
The select max( field ) statement may return the same number to different users using the transacion at the same time unless the table is enqueued and locked first. Inside the generated maintenance this is not an issue as it locks the table and will not allow two users to update. However, if you also use this logic in your own program code you need to make sure no one else is updating at the same time.
Bluesky
