Historical Transaction to table with autonumber primary key ID column

Ignition
1

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.

2

You'll need to show us the table structure and the transaction configuration before anyone could help.

3

Just found my error. It is working fine. Thanks

4

Would it help anyone else if you shared it?

5

I doubt it. My problem was I was working with a second instance of my database for testing purposes. When I saw that the Ignition group had written data, I checked my table and there was not data. What I found was I was checking the table in my first instance of my database and not the table in the database that I was using to test Ignition. Very frustrating, and a waste of my time and yours.

1 Like
6

We've all done stupid stuff!
Thanks for the update.

1 Like