Quality FoxPro Software

Harp1  Business Solutions

When calling UserQ, you can specify to have the Query Selection form appear first, or to go directly into the Query Designer.

The Selection Form allows users to view or edit existing queries, create new queries, delete their own queries, or select a saved query that will be returned to the calling program (if specified).

For example, you could call UserQ from a "Filter" button on your form.  When the user selects a Query, an object is returned by UserQ with properties containing all of the selected query information, such as the Where clause, Fields to show, Order-by fields, etc.  You can then use this information to query the records displayed in your form or report.

UserQ was designed to be three things.  An ad-hoc query tool, a reporting tool (it uses FoxPro's built in report writer), and a "Filtering" selection tool, while providing the control and customizations you require in your application.

When clicking on fields for Selection Criteria, an Expression Builder pops up as shown.

The selections across the top read like an expression (Customer state is in the list "TX,CA").

The "Lookup value(s)" button in the Express Builder is a powerful feature.
When calling UserQ, you can specify for each field, where to go for the lookup values
selection.  The button lets you select single or multiple values from the source table, a master
table, a codes table or even remote tables using SQL Pass-thru.

Expressions can be linked together with AND, OR and parenthesis.

There are over 30 operators/functions to select from.

You're not limited to using dialogs. If you know SQL you can edit your criteria manually.

SQL Injection of non-friendly query commands are checked for and disallowed.

And of course, query definitions can be saved, and modified or executed at a later time.

The "View Table" button brings up a full-featured Table Viewer.

Any of the active query tables can be viewed.

This helps users define their queries because they can see what the data "looks like".

Existing Table Indexes can be selected for viewing, searching and printing.

As search characters are typed, the record pointer moves automatically.

The 'View' button changes the View to vertical or horizontal.

The 'Order' button and the underlined column headers allow selecting different Search Orders.

The 'Print' button can print one or more records in various formats.

The Table Viewer can be used separate from UserQ and has many features of its own.

It can be used for updating records, browsing, selecting, printing, and other functions.

It also has a mover-box capability for selecting single or multiple records.

The right-click menu enables additional options for the user, as show above.

Column control classes can be specified.  By default it uses checkboxes for logical fields,
editboxes for memo fields and textboxes for the others.  It can also use comboboxes for updates.

UserQ provides various functions to perform on the query Results.  Some of the choices are: Printing Results - which allows the use of the report designer, or the option of quickly printing with basic formatting.  The "Save" option allows saving results in various formats.  "Query the Results" allows "drilling" down into query results without re-running the previous query.  Totals and Averages can also be quickly displayed on all numeric fields in the results.

UserQ provides various options for Printing results.  The user can simply print in a standard horizontal or vertical format.  Or they can create report forms, open existing report forms, copy previous report forms or delete report forms.  When you call UserQ you can even specify a fixed UDF report function to run when the user clicks on the Print Results button.  You can also specify which directory report forms are to be saved and opened from.  This prevents users from using secured directories.  The report forms use FoxPro's report designer, so this gives them a powerful tool that you are already familiar with and can provide assistance with if you want to allow users to use this feature.

UserQ lets you Save results in many different formats.  This allows you to transfer information from your queries to other systems or email recipients.  You can even save the results to the Windows Clipboard in a formatted text format for pasting into emails and other documents.