Creation password at runtime

Bruce Easton bruce at stn.com
Wed Jan 17 15:06:42 PST 2007


I am getting prompted for a Creation Password at runtime during the
execution of a called table.  Just doesn't seem fair.   My code uses a
variable name for lookup (for read purposes only) into a qualified key of
the file that seems to be in question here:

        If: 'portion of called table
      Then: ii(2,.0)="1"
iiloop  If: ii gt "30"
      Then: xu=xu+"1"; goto xuloop  'somewhere above all this
        If:
      Then: xf="APP at MD"{ii
        If:
      Then: lookup  thefile = (xf)  k=td  i=A  -ng
        If: not thefile
      Then: xu=xu+"1"; goto xuloop
        If:
      Then: 'other stuff gets done here
        If:
      Then: ii=ii+"1"; goto iiloop

The program does work OK without error, and will return the desired results
if at runtime, I enter the Creation password for the file "APP" - the same
password that is required when I use rcabe for anything that looks up into
that file.  File "APP" has 30+  qualified keys (and for the love of warmer
weather, I have no idea why someone would design it that way, but hey).  SCO
Unix - filePro is 5.0.14.


Bruce Easton
STN, Inc.




More information about the Filepro-list mailing list