lookup to a qualified file with a variable

[James Flanagan]

I want to thank you all for your help.  I have found that the two primary methods suggested both work.  some of my intermediate attempts to get this working failed due to qualified index issues.  

for the record, these methods worked

::company=“google”:
::ln=“employees@“{company:
::lookup emp = (ln) k=(usr) i=a -nx:

and

::company=“google”:
:;lookup emp = (“employees@“{company) k=(usr) i=a -nx:



Again, I appreciate all of your help, especially on a sunday.  Thank you.




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 2:45 PM, Scott Nelson <scott at logicdatasystems.com> wrote:

> Try with k=1 or some other real field, and lookup emp = (“employees@"{company{"") and see if you get an error.
> 
> 
> On 4/6/2014 3:42 PM, James Flanagan wrote:
>> 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/67363879/attachment.html