I am not able to add records to my SQL Table. I am using a histrorical transaction and it says the transaction is running and it shows that it is writing to the table, but the table never has any more records. It has something to do with the ID field of the table. The ID field is a auto number, integer, primary key. If I duplicate the table to a test table that doesn’t have the ID field then I can add records with no problem.
You'll need to show us the table structure and the transaction configuration before anyone could help.
Just found my error. It is working fine. Thanks
Would it help anyone else if you shared it?