PC SOFT
ONLINE REPOSITORY
FOR WINDEVWEBDEV AND WINDEV MOBILE

Home |  | Sign in | English US
Query by Example Class
Published by Pete ( NextAge )
in the category Communication
New features
1.01 - January 16 , 2013


Fixed direct reference to file in DeleteSavedQuery Method
Added some methods used by Browse Form Manager to refresh the table after an update
Resolved issue with Additional Conditions not being applied if no search conditions supplied
Resolved issue with Get Record Count not handling From as first word of line
Resolved issue with Advance SQL where clause not being correct if there are ambiguous field names

Description
NextAge's Query by Example class provide a method of allow end users to filter their data using a simple QBE interface. It allows the them to save thier queries for later reuse as well.

A QBE are three basic modes of QBE HFitler, SQL, and Advanced SQL. Hfilter and SQL work very similarly except one is accomplishing the task via Hfilter, and one uses an SQL statement with HExecuteSQLQuery. The one advantage to the SQL method is the Multiple File Fields will be expose to the QBE interface.

The Advanced SQL method allows complete control of the SQL statement. This requires a table that is set to be filled by programming. With the Advanced SQL mode the data can be fully loaded on initialization or using a Timer function so that the user is able to interact with the browse while records are still loading.

The QBE class was original inspired and some of the base code comes from the training material provided by Glenn Rathke of Software Design Consulting. We highly recommend his training materials to anyone using the WX suite of tools. http://www.sdcdev.net/

More information and the latest version can always be found at http://www.thenextage.com/wordpress/

Illustrations, screen shots
none
none
User reviews
(To evaluate this resource, click 'Write a review')
No review or comment? Be the first one!
ABOUT
RATING:
00No rating
DOWNLOADS:
711
UPDATED:
January 17, 2013
VERSION:
1.01
CONCERNS:
WINDEV
Minimum version: v17
SIZE:
359.3 KB
OF SAME DEVELOPER