A new user to Ignition, dba, and scripting but learning. I am using PostgreSQL as my database. I have successfully created a simple database editor as described in the Ignition user manual 8.0. This editor works great!
When I add data to the table the “id” column is automatically updated and is an index.
Now I have created a new table and cant get the “id” column to update automatically.
I just get a null value in the table.
I am testing it in the Named Query editor.
I had the id column as the primary key and could not get the insert statement to work without explicitly defining every column.
What am I missing? How do I make the id column automatic?
Thanks for the help,