I am using MySQL as a backend. Base is being used as the front end.
I also have PHPmyAdmin installed, which works directly with MySQL. With PHPmyAdmin, the following syntax below works.
START TRANSACTION;
INSERT INTO ServicePlans
( PlanID
, PlanName
, PlanPrice
, DiscountedPrice
)
VALUES (“M1005”, “Messaging Package”, 19.99, 16.99 );
INSERT INTO Orders
( CustomerID
, PlanID
, OrderDate
)
VALUES ( 19, “M1005”, “1015-01-01” );
COMMIT;
Can the syntax above be “translated” into a form that Base can use?
It appears not, as certain text in the Base SQL tab (“tools” → “sql”) appears green, which seems to imply that Base does accept the text. Specifically the text “Start Transaction” and “Commit” appear green which seems to imply that Base is informing you of an incorrect syntax before you even get to execute the code.