The 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 See the special notes section for additional information.
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. Soft Design Consulting, LLC is dedicated to providing the best training in WinDev, WebDev, andWinDev Mobile, and that means we bring numerous years of creating course content and presentation to the WinDev community.
Glenn Rathke, owner of Soft Design Consulting is a seasoned developer and former professor at Roosevelt University in Chicago, IL. Glenn has trained hundreds of developers and students over the years. He incorporates concepts from many proven programming courses as well as his own unique ‘take’ on the WinDev language.
Soft Design Consulting provides and teaches:
1. Elegantly simple user interface which shortens the end user learning curve.
2. Data access across all methods; tables, HFilter, Queries, HExecuteSQLQuery, Stored Procedures, and more…
3. Fast data access which increases productivity.
4. Reusable QBE
5. Implementation of Dynamic Business Rules
Training is available as self study courses which include Our unique real world examples, manual, and streaming videos. We also offer 4 days of on-site training at your facility as well in the St. Louis area. More info can be found at www.sdcdev.net
Enough of a sales job. I hope you enjoy it. If you have any questions, suggestions, complaints (well not complaints) then please use the comments below so we can all benefit from each others additions. This article will be updated with each new release of the class.
If you have any questions about the NextAge Open Source initiative be sure to check out this post.
The Download Links
1.0 – January 9, 2013
1.01 – January 16 , 2013
1. Fixed direct reference to file in DeleteSavedQuery Method
2. Added some methods used by Browse Form Manager to refresh the table after an update.