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

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

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

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

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

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


 


UserQ's Main Features

  • Manages user-defined Query definitions, reports & connections.

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

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

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

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

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

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

  • A utility is included for quickly specifying Database field captions.

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

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

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

  • Join conditions can be specified when querying multiple tables.

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

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

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

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


Selecting Saved Queries


Expression Builder


Table Viewing


The Results button

Printing Results

Saving Results

The Options button

Open New Files to Query option

Specifying Joins

 

Implementing UserQ

 

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


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