(MPE) Alpha Lookup Screen Using Image B-Tree

Pickering, John (NORBORD) John.Pickering at norbord.com
Wed Oct 26 12:33:36 CDT 2005


Why make it so complicated??

How about getting rid of the TEMPs and the DEFINE and changing your access
statement to this:

>access via MIG-CMD-NAME &
>  using tru(MIG-CMD-NAME) + "@" &
>  request MIG-CMD-NAME

Regards,
JWP

-----Original Message-----
From: Blair Combs [mailto:combblai at isu.edu]
Sent: Wednesday, October 26, 2005 12:33 PM
To: Powerhouse Listserv
Subject: (MPE) Alpha Lookup Screen Using Image B-Tree


I am attempting to setup an alpha lookup screen using an image b-tree
but am having difficulty.

The basic skeletons of the dictionary and screen below only shows the
first record matching the selection.

Any assistance would be appreciated.

Additional Question:  When I/we get this working will it also work on
Unix with Eloquence?

*** dictionary record start ***

RECORD MIG-CMD-CODE-A   ORGANIZATION AUTOMATIC MASTER INDEXED
  ITEM MIG-CMD-NAME     DATATYPE CHARACTER SIZE 8
INDEX MIG-CMD-NAME
  SEGMENT MIG-CMD-NAME

*** dictionary record end ***

*** screen source start ***

screen MIGQSALP receiving TEMP-ID act find
;
temp TEMP-ID   char*8
temp TEMP-NAME char*8
def  D-NAME    char*8 = TRUNCATE(TEMP-NAME) + "@"
;
file MIG-CMD-CODE-A occurs 15
     access viaindex MIG-CMD-NAME generic &
            using D-NAME request TEMP-NAME
;
; ** There seems to be some confusion in the doc
; ** concerning generic vs nogeneric
;
align (,3,10)
field TEMP-NAME
;
align (5,,10)
cluster occurs with MIG-CMD-CODE-A
field MIG-CMD-NAME of MIG-CMD-CODE-A
cluster
;
procedure designer 1
begin
    let TEMP-ID = MIG-CMD-NAME of MIG-CMD-CODE-A
    RETURN
end

*** screen source end ***




More information about the powerh-l mailing list