Using SQL Command to Execute Scripts
The SQL Command option allows you to create and execute SQL scripts. The advantage over similar tools (SQL*Plus, I-SQL) is that the SQL option has the conceptual processor check all SQL statements before executing them.
You can only execute SQL scripts after your application tables have been physically created in the database.
Within a script, you can use any action supported by USoft Developer. This action must then be preceded by the ACTION keyword. For example:
action WindowCreate('Info Window', 'Computers')
To execute scripts using SQL Command:
This window only contains the information (tables, columns, computed results, etc.) specified in your script. You can use this window to query, insert, or update data with all the features of a graphical user interface.
This window can also be designed. See Windows Designer help topic: "How to Design Info Windows Created from SQL Command".
You can start a script that has previously been saved as a file, by using the Start command in the upper box of the SQL Command dialog. The syntax is: