I am attempting to use the system.db.runPrepUpdate() function with the getKey parameter set to True.
However I notice the SQL server is returning a column that is not actually the primary key.
This could be due to the fact that the primary key is a non-integer datatype, or due to the fact that there are triggers on the table generating the key... not sure.
I think my solution will lie somewhere in the query / sql db configuration.
But just curious if anyone knew a way around this.
I've tried the OUTPUT INSERTED in the query as seen on stackoverflow but Ignition tells me: "A result set was generated for update"