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;