The command line can be a very helpful tool to detect the cause of an error in a script, quickly see results, open a table that may be hard to find in the project navigator folders, or to quickly display the table layout or history. Below we have summarized the steps to use the command line for these procedures, and how to change your display settings to view the command line.
View Command Line
If the Command Line text box is not visible, select Window from the ACL menu bar and select Show Command Line.
Execute Commands Individually to Find Script Error
To edit and/or re-execute commands recorded in the log file. While you can only enter one command at a time, stepping through the code line by line can be helpful in working backwards and detecting where an issue occurred. This can be done by clicking an entry in the Log, adding it to the command line, and clicking the green play button on the right to run the command.
Open a Table
- To easily find a table that you would like to open in your project, go to the log and click on one of the OPEN commands for the table you would like to open. The command will now be displayed in the command line and will open after running the command.
- After running this command in the command line, there is also the option to use the F4 key to get a list of tables in your project.
Quickly See Results
To quickly evaluate the effects of an expression with the CALCULATE command.
Quickly View Table Layout or History
- To quickly view or print the table layout in ACL, type DISPLAY or DIS in the command line. The table layout has useful information about the fields in a table, such as the length of a field, the field type, and the expressions used to create computed fields.
- To quickly view the table history in ACL, type DISPLAY HISTORY or DIS HIS in the command line. This command will display the history of the current table you have open.