Scripts

Source files : scripts/ScriptName.sqlf

SQL queries

BEGIN TRANSACTION;

COMMIT; -- Save changes made since BEGIN TRANSACTION to disk.

ROLLBACK; -- Discard changes made since BEGIN TRANSACTION.

INSERT INTO myTable ...; -- Number of row inserted is stored in variable insert_myTable.

UPDATE myTable ...; -- Number of row updated is stored in variable update_myTable.

DELETE FROM myTable ...; -- Number of row deleted is stored in variable delete_myTable.

-- In calculated expr :
'Coucou='||(SELECT Field1 FROM myTable WHERE ...)
1+(SELECT count() FROM myTable WHERE ...)

An automatic BEGIN TRANSACTION is fired at start of the script and a ROLLBACK is fired if an error occurs.

Variables

Variable names are made of 'abcdefghijklmnopqrstuvwxyz_1234567890'.

Affectation :

var1=1;

var1='coucou';

var1=1+1; -- 2 is stored.

var1='cou'||'cou'; -- 'coucou' is stored.

var1=(SELECT * FROM myTable); -- Row 0 col 0 value is stored.

var1=(SELECT * FROM myTable WHERE false); -- 0 is stored if no row returned by SELECT.

Usage :

var2=var1+1;

if (var2==var1) {...}

UPDATE myTable SET Field1=var2;

C-like

if (1==2) {
    -- Never
} else if (1==3) {
    -- Never
} else {
    -- Always
}

var1=0;
while (var1<10) {
    ...
    var1=var1+1;
}

return; -- Interrupting and exiting the script.

User dailogs

Functions