Progress
AppBuilder
Developer’s Guide
Defining and Editing Queries Using Query Builder
A central step in developing any database application is creating the query or queries to be used for retrieving records from the database. AppBuilder offers a structured query editor for your use. You can invoke Query Builder in a number of ways:
- Define a new SmartDataObject — AppBuilder then starts the SmartDataObject Wizard, and the Wizard calls Query Builder on your behalf. SmartObjects are the most powerful way to use queries.
- Place a basic Data Browser (Browse) object in the workspace — AppBuilder then starts Query Builder. The Browse object has all the internal logic necessary to make use of the query, though only in a self-contained way. You must manually add any additional logic you require.
- Place a Query object in the workspace — AppBuilder then starts Query Builder. Such a Query object is not connected to anything after you define it. You must manually add the code to make use of it.
- Choose the Query button from the property sheet of a Frame object — AppBuilder then starts Query Builder. As is true of the Query object, you must manually write the code that makes use of this embedded query, after you have finished defining it.
NOTE: You can also construct or modify queries by hand, using AppBuilder’s Section Editor, but such queries cannot later be edited using Query Builder. If you wish to have all queries be maintainable in Query Builder, you would have to replace any such free-form queries with their Query Builder-generated logical equivalents.Query Builder always starts in Table-selection mode.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |