Maintenance Application
45
option if you are certain that you understand SQL and are executing the correct command. By running an SQL command you can inadvertently or even severely damage the data contained in the system database tables. If you are unsure, you should not use this option, contact your Authorized TEC Dealer for technical support.
This example shows the Maintenance application's "File" menu, "SQL command" option.
This option allows a programmer to either select an existing SQL command from the drop down list at the top of the window or manually enter a new SQL command and execute it. It is also possible to enter new commands, then save them to have them added to the existing list.
4.4.1Item Options
Item Maintenance Utilities
The "PLU" desktop icon and the "PLU" menu's "Item" option both open the Item table programming utility. Once open, the Maintenance application's "File" menu adapts to include options and utilities that apply specifically to item table. The options and utilities are designed to work with item data entry and programming integrity.
Item Table File Menu Options
Tests: This option includes item tests that help control item data integrity, such as
PLU at zero price in level 1: Items should have a price on level 1! This tests the item tables for any items that do not have a price on price level 1, and opens a list box. If there are no items without a price, the list is empty. If there are items without a price, you can double click an item to edit it right away. You can then either edit or delete the item in question. Repeat the process until all items have been dealt with.
NOTE: Items can exist without a price. The Maintenance application will not stop you from creating an item, then leaving the item table without entering a price.
No
