Kbase P78541: How to specify the fields in the Field-List for a table using the AppBuilder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/29/2004 |
|
Status: Unverified
GOAL:
How to specify the fields in the Field-List for a table using the AppBuilder?
GOAL:
How to set the Fields clause for a query in AppBuilder?
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
Windows
FIX:
The Fields option specifies a list of fields to include or exclude when Progress retrieves records using a FOR, DO PRESELECT, or REPEAT PRESELECT statement. Field lists are also available for queries using the DEFINE QUERY statement. To define the Fields list for a query using the AppBuilder, perform the following steps:
1- Fire up AppBuilder and establish a connection to a Progress database
2- Choose the AppBuilder's File -> New... menu and then select the Window object.
3- Next, hit the Browse button on the Progress Palette and drop it on the created Window by clicking on the Window's frame with the mouse.
4- On the Query Builder Dialog-box, highlight the desired table from the list of Available Tables and hit the Add>> button to transfer the highlighted table to the list of Selected Tables & Joins.
5- Next, click on the Fields... button and add the fields to be displayed on the browser.
6- Then, back on the Query Builder Dialog-box, choose the Options radio-set button and double-click with the mouse on the Returned column value (All Fields). It should change from "All Fields" to "Fields Used".
7- Hit OK on the Query Builder Dialog-box and run the created Window.