Progress
Application Development
Environment — Getting Started
Dynamic Query Module
Before Progress Version 9, you had to define the selection criteria at compile time. You could achieve limited flexibility by using IF...THEN...ELSE or CASE statements. Progress Version 9 introduced new language elements that enable you to build dynamic queries. With the dynamic query structure, you do not have to anticipate every case for which an end user might want a query. At run time, end users can design their own queries to fit exactly the questions they need to answer.
Choose the Dynamic Query button on the SportsPro main window to launch this module:
![]()
When you launch the Dynamic Query module, it accepts the handle of a SmartDataObject on the SportsPro main window to serve as the data source for the query. As you create a query using the buttons in the upper section of this window, the module records the contents of the For Each Customer Where editor as a variable. Choosing the Search button launches the module’s Search procedure. The Search procedure accepts the handle of the user input variable and uses it to replace the SmartDataObject’s WHERE and SORT clauses.
Table 2–3 describes the major objects used in the Dynamic Query module.
NOTE: The Dynamic Query module also runs when you choose the Find Customer button in the Customer section of the SportsPro Order Tracking System.For more information on building dynamic queries, see the chapter on using dynamic widgets in the Progress Programming Handbook .
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |