SQL Syntax Embedded in Method Call Scripts
To embed SQL method call scripts, use the SqlScript() and FORMULA() methods, or call a decision using ActionDecision().
To perform database queries or data manipulation in non-SQL contexts, call the USoft-native SqlScript() method and provide the SELECT, INSERT, UPDATE or DELETE statements as a parameter.
To delete all child records corresponding to an on-screen primary key value, write:
DELETE FROM RESERVATION
WHERE schedtour_id =
To call SQL functions such as ROUND() or the concatenation function in non-SQL contexts, use the USoft native FORMULA() method.
To write a date 3 days later than the current on-screen book date in a text box, write:
Variables.Text_Box_1( FORMULA( ':1 + :2', query.bookdate(), '3' ) )
To perform database queries and use the retrieved values for further processing, call ActionDecision() in your method call script. An example of data retrieval in the Decision SQL is:
WHERE person_id = :"query.made_by"
The Decision Yes Action could read:
where the :1 placeholder represents the value(s) retrieved by the Decision SQL query.