[quote]INSERT INTO ord_sales_gen (OrdNo, OrdDate, FK_Corp_ID, FK_Valuta)
SELECT OrdNo+1, ‘2017-07-16’, 7, 1
FROM ord_sales_gen
WHERE id=LAST_INSERT_ID();
SELECT OrdNo FROM ord_sales_gen WHERE ID=LAST_INSERT_ID()[/quote]
This instruction that works fine in MySql, cannot be used in Xojo Mysql Qry.
transactions are the right way to make sure things get inserted “as expected” and are the right way to handle multi user potential conflicts and errors
for reading data its not a big deal since there can be many readers at once - but for insert , update, delete they are an absolute MUST to get the right results