Saved Query Viewer

Help System

Saved Query Viewer

The Saved Query Viewer allows you to load and re-run Wizard Generated as will as hand entered SQL Statements.  There are two panels, BASIC and ADVANCED.

 

BASIC OPERATION:

You can select from a list of saved SQL Statements to run.  Pull down the selection list, choose a query, and click on the RUN QUERY button to view your results.

ADVANCED OPERATION:

You can enter, edit or paste from your clipboard any SQL Statement.  You can then give the SQL Query a friendly name, and select a group category for later classification, and save it.  Once you have edited and saved your query, you can return to BASIC OPERATION and run it.

HELPFUL TIP:
You can use either the MS SQL Server Management Studio, or the older Enterprise Manager to generate complex and useful queries, then "cut and paste" them right into this panel for use anytime in Trak Pro.

 

See Also:

POS Operator Listing
POS Station Listing
POS Operator Login Report
Customer Listing
Saved Query Viewer
Query Results Viewer
Crystal Report Viewer