lookup to a qualified file with a variable

[Scott Nelson]

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
>
>