UserQ - Query & Reporting

Home

Query and Reporting

Harp1  Business Solutions

Products
F.A.Q.
Suggestions
Downloads
Purchase
Contact Us

UserQ
User-defined Query and Reporting
for Visual FoxPro
 

Easily include Ad-hoc Query features in your applications!
See the Demo Video

Version 8.84
Released 10/22/2004

For VFP 7 - 9


UserQ is a complete, User-defined, Ad-hoc Query and Reporting add-in
for your applications.  Or use it as a stand-alone developer's tool.

(The example screen shows a simple query on a customer table).
 

bullet

UserQ enables users to quickly and easily query and report on the information they want to see.

bullet

UserQ can be used as a "Selection Criteria" add-in for forms and reports.

bullet

UserQ is especially suited for large databases with features that help users optimize their queries.

bullet

UserQ can query FoxPro tables as well as non-FoxPro data sources using SQL Pass-thru.

bullet

UserQ is:
    Easy to implement!
    Simple to Use!
    Flexible, with many options and security features!


 


UserQ's Main Features

bullet

Manages user-defined Query definitions, reports & connections.

bullet

Queries can be saved and recalled by Query name, User ID, User group and Query type.

bullet

UserQ allows you to "Query the Results" for narrowing down queries on large databases.

bullet

Query results can be printed using the Report Designer or quickly listed in various formats.

bullet

Query results can be passed to custom procedures or FoxPro report forms.

bullet

Query results can be saved in various file formats (Excel, DBF, Delimited, SDF, etc.)

bullet

Query definitions can be returned to calling programs for use in your forms & reporting functions.

bullet

A utility is included for quickly specifying Database field captions.

bullet

Table indexes are selectable for Optimizing Rushmore* using single and multi-field indexes.

bullet

Non-FoxPro Remote databases are queried using SQL Pass-thru so that only the results are returned.

bullet

Remote and local "Lookup tables" can be used for selecting values when defining Selection Criteria.

bullet

Join conditions can be specified when querying multiple tables.

bullet

SQL Injection commands are checked for and disallowed in query definitions.

bullet

A powerful "Table Viewer" is available for helping users define their queries.

bullet

UserQ is incredibly flexible - with many Custom options and Security features.

bullet

UserQ includes "Fully commented" source code, Windows style Help and complete documentation.
 


Selecting Saved Queries

bullet

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

bullet

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).

bullet

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.

bullet

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.


Expression Builder

bullet

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

bullet

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

bullet

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.

bullet

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

bullet

There are over 30 operators/functions to select from.

bullet

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

bullet

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

bullet

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


Table Viewing

bullet

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

bullet

Any of the active query tables can be viewed.

bullet

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

bullet

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

bullet

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

bullet

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

bullet

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

bullet

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

bullet

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

bullet

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

bullet

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

bullet

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

bullet

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.


The Results button

bullet

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.

Printing Results

bullet

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.

Saving Results

bullet

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.

The Options button

bulletThe Options button allows Opening Files, displaying the generated SQL (for copy and pasting), displaying File info, change print font size for quick prints of results, and whether to show field descriptions from the data dictionary, the DBC, or just the field names and their characteristics (type and length).

Open New Files to Query option

bulletWhen running UserQ, you can specify whether to allow users to open tables.  Or, you can specify which files the users can query on.  You can also create connections and views to non-FoxPro databases through the "Maintain Views" and "Maintain Connections" options.

Specifying Joins

bulletWhen running UserQ, you can also specify whether users are allowed to open multiple tables, or only single tables.  When multiple tables are queried, you can easily create Join Specifications by selecting the Add Join button in the Join Tables tab.

 

Implementing UserQ

bulletImplementing UserQ in applications is extremely simple. Just instantiate the parameters object, set parameters, and call UserQ.  It can be run as a general purpose query allowing files to be selected and opened.  Or it can be called from various points in your application with query files specified and various options selected.

For developers, UserQ is also a powerful stand-alone query tool that is quick and easy to use for verifying and looking at data.  It provides browsing, printing, searching, querying and extracting information.  And of course, it allows queries to be saved and recalled easily at a later time.

 

There's More...

UserQ is 100% FoxPro (no external binaries, libraries or ActiveX controls).  It is compact, easy to use, and includes complete Windows-style Help, Documentation, and fully Commented Source code.

Price

UserQ for VFP 7 - 9:  $ 149

Purchase now!

Includes:

Multi-developer Enterprise license with
Complete source code (for use within your organization)
Distribution Rights (in compiled format),
 
a 30-day money back guarantee,
and free upgrades!
 


UserQ Demo Video

Click on the Windows Media Video below to see a demo of UserQ.
Note: If the video does not play sound and video, you may need to update your Windows Media Player by going to:
http://windowsupdate.microsoft.com

UserQDemo.wmv
(Streaming video, 12 minutes)
 


Evaluation Download

The following evaluation is available for download.
This is compiled under VFP version 9.
You will need the VFP9 runtime installed to execute this.
The evaluation is limited to 5 saved queries and a period of 30 days.

Download UserQ09e.zip for VFP9
(360K)
 

Give it a try!
See how easy it can be to add a full-featured,
User-defined Query to your applications.

To see UserQ and Expression Builder in action, take a look at our Vacation Rental Software for vacation rental properties at: www.VacationRentPro.com

horizontal rule

* FoxPro, Visual FoxPro, Windows, SQL Server and Rushmore are registered trademarks of Microsoft Corporation.

 Bookmark this page to check for new versions.

(C) Copyright 1996 - 2008 Mark Harpenau, All Rights Reserved.

 

To see UserQ and Expression Builder in action, take a look at our Vacation Rental Property Management Software: www.VacationRentPro.com

horizontal rule

Home | Products | F.A.Q. | Suggestions | Downloads | Purchase | Contact Us

Questions or problems regarding this web site should be directed to support 'at' userq.com.
Copyright 2008 Mark Harpenau. All rights reserved.
Last modified: 06/05/08.