Quick Query will generate an additional search screen based on your edit screen.

Select the thumbnail to view a search screen created by Quick Query (10KB)

The end user will be delighted. There is nothing new to learn because it looks essentially like the screen s/he uses to enter data: same color, same general layout, same objects related to the data. With the new screen s/he can ask questions. Most queries are straightforward: enter an item to be found, click on the RUN QUERY button and see the result.

The end-user can view the query in plain English, or see the complex query code. Queries can be saved and retrieved with a title up to 46 characters long. You can output queries to labels, reports, DBFs, cursors, or a wide variety of formats, including Lotus.

Real power is available by clicking the object and the OPTIONS button. Each data type has its own options screen.

The query can be as simple as “movies produced in 1994” or as complex as “movies produced in 1994 AND the second letter of the title is in the list 'a, g, w'.”

The default mode will ignore case, spaces and punctuation. Simple queries are Rushmore optimizable.

QuickQury.PRG turns your program or screen into a powerful customized query screen when placed in WHEN and VALID clauses of GET objects.

• Easily handles related multi-table databases
• Customizable, context-sensitive HELP
• An end user's manual that can be incorporated into your documentation is included
• Source Code Included
• Queries can be saved and recalled
• Descriptive titles are taken from the edit screen, directives or a data dictionary
• Option screen defaults can be configured during development or at run time
• All keys are programmable
• Parentheses are automatically balanced
• If a flat file is used, the selected record number is available, and the record point is positioned on the record selected. This facilitates search and edit applications.

QuikQrys.EXE creates a custom query screen based on your edit screen. The custom query screen is a normal screen file. It can be fine-tuned in the screen builder and called like any screen file.

QuikQrys.EXE also adds setup code, cleanup code and buttons across the bottom of the query screen.

A rich set of screen directives is available. They can be posted in the edit screen directly as comments, through a configuration file, or from the directives dialog screen. Their power includes:

• Additional SQL and descriptive clauses
• Your default output macro or user defined function
• Additional setup or cleanup codex
• Additional SQL code and query description
• Quick Query goes to work effortlessly integrating user defined queries into your application. There is absolutely no need to include a huge generating engine because there are no APP files to add overhead.