SQL sample statements

Statemenst for testing LiteDAC vs. FireDAC with SQLite

The create data statements script

DROP TABLE IF EXISTS TableA;
DROP TABLE IF EXISTS TableB;
CREATE TABLE TableA (
  IDFieldA INTEGER
 ,ValueFieldA INTEGER
);
INSERT INTO TableA VALUES (25,3);
INSERT INTO TableA VALUES (36,2);
INSERT INTO TableA VALUES (38,1);

CREATE TABLE TableB (
  IDFieldB INTEGER
  ,ValueFieldB INTEGER
);
INSERT INTO TableB VALUES (36,287);
INSERT INTO TableB VALUES (37,311);
INSERT INTO TableB VALUES (38,127);
SELECT * FROM TableA;

The transaction statements script

BEGIN TRANSACTION;
UPDATE TableA
SET ValueFieldA =
 (SELECT b.ValueFieldB
  FROM TableB b
  WHERE IDFieldB = TableA.IDFieldA
 )
WHERE IDFieldA IN
 (SELECT IDFieldB
  FROM TableB
  WHERE IDFieldB = TableA.IDFieldA
 )
;

The transaction COMMIT statement script

COMMIT;
SELECT
* FROM TableA;

The transaction ROLLBACK statement script

ROLLBACK;
SELECT
* FROM TableA;