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