Hello,
I have been working on a split database and one of my forms involves copy data from one table on the back-end database to another back-end table. Prior to copying the data to the destination table I copy it to two temp tables to modify and insert new data.
My issue is that when I am trying to edit data, by means of a record set, on the second temp table, the form just stops updating. It does not throw an error, crash, or continue to the rest of the form -- it just stops processing.
I attached a copy of the form's code. The area I am talking about begins after the following comment area:
'
' Second Part: Insert distinct rows into active steps 2 AND add the order_number. The order of the steps is based on Task_ID and Sys_Step_ID.
'
Thank you,
Ed W.
I have been working on a split database and one of my forms involves copy data from one table on the back-end database to another back-end table. Prior to copying the data to the destination table I copy it to two temp tables to modify and insert new data.
My issue is that when I am trying to edit data, by means of a record set, on the second temp table, the form just stops updating. It does not throw an error, crash, or continue to the rest of the form -- it just stops processing.
I attached a copy of the form's code. The area I am talking about begins after the following comment area:
'
' Second Part: Insert distinct rows into active steps 2 AND add the order_number. The order of the steps is based on Task_ID and Sys_Step_ID.
'
Thank you,
Ed W.
Attachments
Last edited: