Progress
Results User’s Guide
for UNIX


Determining Files and Selection Criteria

Use the following shared variables in your Progress procedures to determine the files and selection criteria defined when the user selects the User module.

DEFINE SHARED VARIABLE qbf-db    AS CHARACTER EXTENT 5 NO-UNDO.
DEFINE SHARED VARIABLE qbf-file  AS CHARACTER EXTENT 5 NO-UNDO.
DEFINE SHARED VARIABLE qbf-where AS CHARACTER EXTENT 5 NO-UNDO.
DEFINE SHARED VARIABLE qbf-of    AS CHARACTER EXTENT 5 NO-UNDO. 

When using these shared variables:

NOTE: Code similar to this is used in the u-export.p sample export format program in the "Designing Your Own Export Format" section in this chapter.

Use this program listing in conjunction with the qbf-file, qbf-where, and qbf-of shared variables to produce a Progress 4GL selection statement similar to the following.

FOR EACH sports.customer, EACH sports.order OF sports.customer,
   EACH sports.order-line 
      WHERE sports.order.order_num =sports.order-line.order-num . . . 

This program is important because you use these entry points to determine the files and selection criteria already defined when the User module was selected. Note that when there is a join operation, Results shows all parent relationships, not just the immediate parents.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095