PC SOFT
DEPOT EN LIGNE
POUR WINDEVWEBDEV ET WINDEV MOBILE

Query by Example Class
Publié par Pete ( NextAge )
dans la catégorie Productivité
Nouveautés
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, copies d'écran
none
none
Avis des utilisateurs
(Pour noter la ressource, cliquez sur Ecrire un avis)
Aucun avis ou commentaire ? Soyez le premier !
A PROPOS
EVALUATION :
00Aucune évaluation
TELECHARGEMENTS :
516
MISE À JOUR :
17 janvier 2013
VERSION :
1.01
CONCERNE :
WINDEV
Version minimale : v17
TAILLE :
359,3 Ko
DU MÊME DÉVELOPPEUR