This is Windows 19.1
The Help for Begin_Transaction says
- You do not need to explicitly use Begin_Transaction… End_Transaction for database operations that are executed and controlled by DataDictionary objects.
Question: Does this include Adding a row to a table where the Datadictionary Creating procedure has code to set a unique ID from another table. This is NOT using the Field_Auto_Increment feature. Rather it increments a numeric field in the control table, converts it to a code and uses the code. In Creating for the main table it does a Saverecord on the control table after doing the increment.
We recently had a system stop because of a duplicate record on Index.02 field ID noted above
Index.01 field is Idn that is set by Field_Auto_Increment and has not had a problem.
Should I add begin_transaction and end_transaction around the code in the program that adds the record, currently:
Send Request_Clear of hoDD
Set File_Field_Changed_Value of hoDD File_Field ediTask.WaitMinutes to iWaitMinutes
...
Send request_Save of HoDDD
Thanks
Archie