Strange....

[David Frederick (714)639-9951 x132]

>Terry 
> 
>QDESIGN will not assume from the REQUEST that you mean USING.  If you had 
>coded the ACCESS as  
> 
>FILE GLS-CODE-TBL 
>  ACCESS VIAINDEX SELECT-CODE-KEY USING select-code REQUEST SELECT-CODE 
>  ACCESS SEQUENTIAL 
> 
>I believe your FIND statement would default to what you hard coded. 
> 
>BTW, if you ever intend to migrate from RMS flat files to a RDBMS, you
>should 
>avoid using dashes in the filenames.  E.g. use SELECT_CODE rather than 
>SELECT-CODE.  Some RDBMS' don't like hyphenated table or column names.  Rdb
>is 
>one. 
> 
> 

    On the same topic of going from RMS to RDBMS... it's also wise to use 
    VIA and reference the segments rather than VIAINDEX, which references 
    the index name.  Unlike the PowerHouse dictionary, many relational 
    database engines, like Oracle Rdb, require that all index names be 
    unique.  In the PowerHouse dictionary, index names only need to be 
    unique within a particular record definition.
    
    All this to say that a conversion to Rdb may involve renaming indexes 
    whereas the segment names wouldn't need to change.  So, using VIA 
    whenever possible could save some on coding changes later.  Plus, in my 
    opinion, referencing the segments is much more straight-forward than 
    referencing an index name when you're trying to read and interpret a 
    PowerHouse program.
    
    David Frederick
    Computer Systems Manager
    Wycliffe Associates
    Internet:  David_Frederick@wycliffe.org
    ----
    Disclaimer: Opinions expressed may not reflect those of my employer.
    
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.