I just ran these two SQL Statements without an error here:
SQL Statement 1 - Data query: INSERT INTO "SalesOrderLine" ("CustomerRefListID", "RefNumber", "SalesOrderLineItemRefListID", "SalesOrderLineDesc", "SalesOrderLineQuantity", "SalesOrderLineRate", "SalesOrderLineAmount", "FQSaveToCache") VALUES ('120000-1045537156','1019', '90000-1045537150', '4m Steel Ladder', 1.00000, 1.00000, 150.00, 1)
SQL Statement 2 - Trigger query to close FQSaveToCache: INSERT INTO "SalesOrderLine" ("SalesOrderLineDesc", "FQSaveToCache") VALUES ('', 0)
You possibly need to check the statement before your trigger. Both of these statements need to be run without breaking the connection (within the same connection). |