lookup to a qualified file with a variable

[James Flanagan]

I get the following error:

*** A filePro Error Has Occurred ***

Input Processing
Line Number: 13

lookup (“employees@"{company{"") k=(usr) i=a -nx
^

lookup (“employees@"{company{"") k=(usr) i=a -nx


Process contains a syntax error at position indicated.

In case it matters, I am using Filepro 5.7.04 on FreeBSD 9.2.  thanks, 

James Flanagan
Flantec.com

email:	James at Flantec.com
mobile:	760-458-8498
home: 	219-221-6219
text:		7604588498 at txt.att.net

aim:		Flantec
oovoo:	Flantec
Skype:	Flantec
ichat:	Flantec at mac.com

home:	1901 Cidermill Road
		Michigan City, IN 46360

On Apr 6, 2014, at 1:31 PM, Scott Nelson <scott at logicdatasystems.com> wrote:

> The lookup sytax is this:
> 
> lookup ("employees@"{company{"")
> 
> 
> 
> 
> 
> On 4/6/2014 3:01 PM, James Flanagan wrote:
>> I am trying to lookup to a qualified file with a variable, but I have not been able to make it work.  Assuming that I end up with 40 or 50 qualifiers, this method seems to be the only reasonable way to program this out.
>> 
>> I cannot use the @qu, because the master code will always be run without a qualifier for all companies, but depending upon who is logged in, it will need to both lookup and save to the appropriate qualified files.
>> 
>> lets say i have the following qualified files:
>> 
>> employees at google
>> employees at yahoo
>> employees at fptech
>> 
>> and just to keep the code super simple, i have the following code:
>> 
>> ::declare local company:
>> ::company=“google”:
>> ::lookup employees@(company) k=(aa) i=a -nx:
>> 
>> no matter what i try, it seems to ignore the “(company)” and treat the lookup as if it is just "employees@“ .
>> 
>> Please tell me that i am overlooking something.  Thank you very much,
>> 
>> 
>> 
>> 
>> James Flanagan
>> Flantec.com
>> 
>> email:	James at Flantec.com
>> mobile:	760-458-8498
>> home: 	219-221-6219
>> text:		7604588498 at txt.att.net
>> 
>> aim:		Flantec
>> oovoo:	Flantec
>> Skype:	Flantec
>> ichat:	Flantec at mac.com
>> 
>> home:	1901 Cidermill Road
>> 		Michigan City, IN 46360
>> 
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140406/6cfea42d/attachment.html
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>> 
>> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140406/359fd357/attachment.html