Filepro Error

[Kenneth Brody]

On 11/22/2011 9:15 PM, Saroj Tripathy wrote:
> Hello All,
>
> I am new to Filepro. I am using filepro version 5. When I am accessing a Qualifier (Say, qual1) of a filepro file, I am getting an error which reffering to another filepro. Error say as below
>
>
> *** A filePro Error Has Occurred ***
> On File: //filepro/<ANOTHER FILE>/key<Quanlifier Name>
> Automatic Processing
> Line Number: 84
> File not found
>
> Why I am getting this error? What "key<Quanlifier Name>" stands for? I see "key<Quanlifier Name>" files in some Filepro tables and other I don't see these key qualifier files. Why so?

Qualifiers are a way of keeping multiple sets of data under the same filePro 
file.  For example, you may keep previous years' data archived with the 
qualifier of the year.  Or, you may have multiple businesses or subsidiaries 
where the qualifier is the company name.

Why do some of your files have qualifiers when others do not?  You would 
have to ask the person who set up your system.  For example, even if you 
have several companies, a zipcode file would only have a single set of data.

There are two possibilities why the lookup is failing.  Either "<ANOTHER 
FILE>" should have the qualifier, in which case you need to find out why it 
doesn't, and if it's okay to simply create it without any data; or the 
lookup should always to be the non-qualified file, in which case you need to 
add an "@" after the filename in the lookup, to force the lookup to use the 
non-qualified data set.  (A lookup can specify a specific qualifier by using 
"filename at qualifier" as the filename.  By using "filename@", you force the 
non-qualified data set.)

-- 
Kenneth Brody