lookup to a qualified file with a variable

[Scott Nelson]

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 <http://Flantec.com/>
>
> email:James at Flantec.com <mailto:James at Flantec.com>
> mobile:760-458-8498
> home:219-221-6219
> text:7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>
>
> aim:Flantec
> oovoo:Flantec
> Skype:Flantec
> ichat:Flantec at mac.com <mailto: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 
> <mailto: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 <http://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 
>> <mailto: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/e4577763/attachment.html