Are Ignition Clients each their own independent SQL clients for the purposes of client or button scripts which use system.db.runQuery?
I’m testing a project which will read from a MySQL database which has several tables with autoincrement columns. In order to maintain consistency in the DB, I need to get the autoincrement values after each insertion, and then insert those values into some other tables. The MySQL docs indicate that the way to do this is by querying LAST_INSERT_ID(), and that this value is client-independent. So, as long as each individual Ignition client sets up its own connection to the database, and acts as an independent SQL client, there shouldn’t be any issues with having multiple clients making insertions and then attempting to retrieve their autoincrement values.
Can anyone speak to this? Is that how Ignition works?