lookup to a qualified file with a variable

[James Flanagan]

I do not get the error, but it acts like the company qualifier is blank, just like my original programming attempts.  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 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/c93605e5/attachment.html