[quote=“Andre”]I’m not 100% sure how but i got it working with this query. UPDATE and SET must be different?[/quote]/ me smacks forehead /
I just looked closer at the INSERT statement that I commented on – I was so focused on the quotes that didn’t belong with the question marks. INSERT statements that supply values don’t have WHERE clauses. You list the column names and the values that go with them:INSERT INTO tablename (columnname1, columnname2, ...) VALUES (value1, value2, ...)UPDATE statements list the assignments to make and a WHERE clause that limits the changes to the desired rows (or not – you can change all the rows in the table if you like):UPDATE tablename SET columnname1=value1, columnname2=value2, ... WHERE ....
Hope that helps.
[quote=“Andre”]That explanation should be added to the help file![/quote]Well, Ignition is agnostic on which database product you should use, and there are syntax differences, so a referral is a bit more reasonable.
I’m a fan of PostgreSQL, so here you go: Inserting Data and Updating Data.