Toshiba Electric Keyboard - Manual (Page 147)

Report System 145
© 2005 TOSHIBA TEC AMERICA AMERICA RETAIL SYSTEMS, INC. R1.0a
The SQL editor window is divided into four (4) parts:
·The SQL editor is the top left portion of the screen, and contains the commands for the report.
·The tool bar.
·The upper right of the window shows the prompts used in the Report SQL file to collect the language,
start and end dates, period type, store number and cashier number from the user. The editor reads the
code at load time and displays all prompts it finds in the report file when you open the Editor.
·The bottom portion of the editor window is empty when first opened. It is used to view the results of
the SQL commands in table format with the field numbers as column headers (not as a formatted
report) after pressing the "Test" toolbar button.
Tool Bar Tools
Test: tests the currently loaded query and displays the results in table format. Use this to test changes
to the query and get immediate results.
View Qry: Opens a panel displaying the current version of the loaded report query. The panel also
contains an "execute" option that runs the query displaying the results in table format (like the test
option).
Re-Read: If you make changes to the report file, for example adding new prompts, this forces the
editor to re-read the code and refresh the upper right pane that shows the prompts used in the code.
Save: The save button is "greyed out" until you actually change the loaded query. This saves the
modifications in the .sql file.
Close: Closes the Report SQL Editor window. If changes were made to the query, the close process
will prompt to save the modifications.
NOTE: The editor has a "SIL field decoder" feature (field numbers like F1024). While editing the code,
if the cursor is anywhere in a field number, the field's description is displayed in the Editor window's top
bar beside the report file name. Click any "F" field in the query to see which field is referenced.
This example shows the Editor's SIL field decode feature. The cursor is on the first field in the query -
(F1185)
6 Entry Module
Entry Module Overview