enter creation password when lookup with qualifiers?

[Bruce Easton]

Nancy Palmquist wrote Tuesday, January 29, 2008 5:13 PM:
> Scott Nelson wrote:
> > Kenneth Brody wrote:
> >> Quoting Scott Nelson (Tue, 29 Jan 2008 07:36:15 -0800):
> >>
> >>> Kenneth Brody wrote:
> >>>> Quoting Scott Nelson (Mon, 28 Jan 2008 17:32:29 -0800):
> >>>>
> >>>>> Is it normal for the 'enter creation password for filename' prompt 
> >>>>> when
> >>>>> doing a lookup using a qualifier?
> >>>> Assuming you mean at runtime, the answer is "no".
> >>>>
> >>>> It is, however, normal for it to appear at runtime when using a 
> >>>> variable
> >>>> for the filename.
> >>>>
> >>> That is it.  But why if there is a variable????
> >> ky = "myself"
> >> fn = "employees"
> >> lookup salary = (fn) k=ky i=a -nxp
> >> salary[10] = salary[10] * "1.5"
> >> write salary
> >>
> > So if I am using qualifier as a variable and not the filename, 
> then this 
> > would stop asking?
> Scott,
> 
> The qualifier is part of the filename.  So I would say no it will 
> not stop 
> asking.  YOu must have a file with a creation password that it is 
> trying to 
> limit access for that file.
> 
> lookup salary = myfile at 2008 k=ky i=a -nxp
> 
> would work, but
> 
> lookup salary = ("myfile@"{year) k=ky i=a -nxp
> 
> would still be variable.  So it might not work.  Not sure if 
> filePro just looks 
> at myfile to see if it has a creation password in this case.
> 
> Nancy

The latter lookup will ask for a creation password at runtime if 
there is one on "myfile".

Bruce

Bruce Easton
STN, Inc.