<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>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. </div><div><br></div><div>for the record, these methods worked</div><div><br></div><div>::company=“google”:</div><div>::ln=“employees@“{company:</div><div>::lookup emp = (ln) k=(usr) i=a -nx:</div><div><br></div><div>and</div><div><br></div><div>::company=“google”:</div><div>:;lookup emp = (“employees@“{company) k=(usr) i=a -nx:</div><div><br></div><div><br></div><div><br></div><div>Again, I appreciate all of your help, especially on a sunday. Thank you.</div><div><br></div><div><br></div><div><br></div><div><div>
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); "><br class="Apple-interchange-newline">James Flanagan</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="text-decoration: underline; "><a href="http://Flantec.com/">Flantec.com</a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); min-height: 14px; "><br></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">email:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:James@Flantec.com"><span style="text-decoration: underline; color: rgb(0, 106, 227); ">James@Flantec.com</span></a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">mobile:<span class="Apple-tab-span" style="white-space: pre; "> </span>760-458-8498</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">home:<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>219-221-6219</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">text:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:7604588498@txt.att.net"><span style="text-decoration: underline; color: rgb(0, 106, 227); ">7604588498@txt.att.net</span></a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); min-height: 14px; "><br></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">aim:<span class="Apple-tab-span" style="white-space: pre; "> </span>Flantec</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">oovoo:<span class="Apple-tab-span" style="white-space: pre; "> </span>Flantec</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">Skype:<span class="Apple-tab-span" style="white-space: pre; "> </span>Flantec</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">ichat:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:Flantec@mac.com"><span style="text-decoration: underline; color: rgb(0, 106, 227); ">Flantec@mac.com</span></a></span></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); min-height: 14px; "><br></div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); ">home:<span class="Apple-tab-span" style="white-space: pre; "> </span>1901 Cidermill Road</div><div style="margin: 0px; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-family: Helvetica; color: rgb(121, 121, 121); "><span class="Apple-tab-span" style="white-space: pre; "> </span>Michigan City, IN 46360</div></span>
</div>
<br><div><div>On Apr 6, 2014, at 2:45 PM, Scott Nelson <<a href="mailto:scott@logicdatasystems.com">scott@logicdatasystems.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type">
<div bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Try with k=1 or some other real field,
and lookup emp = (“employees@"{company{"") and see if you get an
error.<br>
<br>
<br>
On 4/6/2014 3:42 PM, James Flanagan wrote:<br>
</div>
<blockquote cite="mid:598866F1-E117-4D26-BAA5-42AAC3CA2EA5@Flantec.com" type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
I get the following error:
<div><br>
</div>
<div>
<div>*** A filePro Error Has Occurred ***</div>
<div><br>
</div>
<div>Input Processing</div>
<div>Line Number: 13</div>
<div><br>
</div>
<div>lookup (“employees@"{company{"") k=(usr) i=a -nx</div>
<div>^</div>
<div><br>
</div>
<div>lookup (“employees@"{company{"") k=(usr) i=a -nx</div>
<div><br>
</div>
<div><br>
</div>
<div>Process contains a syntax error at position indicated.</div>
<div><br>
</div>
<div>In case it matters, I am using Filepro 5.7.04 on FreeBSD
9.2. thanks, </div>
<div>
<span class="Apple-style-span" style="border-collapse:
separate; border-spacing: 0px;">
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
"><br class="Apple-interchange-newline">
James Flanagan</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="text-decoration: underline; "><a moz-do-not-send="true" href="http://flantec.com/">Flantec.com</a></span></div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
min-height: 14px; "><br>
</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">email:<span class="Apple-tab-span" style="white-space: pre; "> </span><a moz-do-not-send="true" href="mailto:James@Flantec.com"><span style="text-decoration: underline; color: rgb(0,
106, 227); ">James@Flantec.com</span></a></span></div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
">mobile:<span class="Apple-tab-span" style="white-space:
pre; "> </span>760-458-8498</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
">home:<span class="Apple-converted-space"> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>219-221-6219</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">text:<span class="Apple-tab-span" style="white-space: pre; "> </span><a moz-do-not-send="true" href="mailto:7604588498@txt.att.net"><span style="text-decoration: underline; color: rgb(0,
106, 227); ">7604588498@txt.att.net</span></a></span></div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
min-height: 14px; "><br>
</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
">aim:<span class="Apple-tab-span" style="white-space:
pre; "> </span>Flantec</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
">oovoo:<span class="Apple-tab-span" style="white-space:
pre; "> </span>Flantec</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
">Skype:<span class="Apple-tab-span" style="white-space:
pre; "> </span>Flantec</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(0, 106, 227); "><span style="color: rgb(121, 121, 121); ">ichat:<span class="Apple-tab-span" style="white-space: pre; "> </span><a moz-do-not-send="true" href="mailto:Flantec@mac.com"><span style="text-decoration: underline; color: rgb(0,
106, 227); ">Flantec@mac.com</span></a></span></div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
min-height: 14px; "><br>
</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
">home:<span class="Apple-tab-span" style="white-space:
pre; "> </span>1901 Cidermill Road</div>
<div style="margin: 0px; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 12px; line-height:
normal; font-family: Helvetica; color: rgb(121, 121, 121);
"><span class="Apple-tab-span" style="white-space: pre; ">
</span>Michigan City, IN 46360</div>
</span>
</div>
<br>
<div>
<div>On Apr 6, 2014, at 1:31 PM, Scott Nelson <<a moz-do-not-send="true" href="mailto:scott@logicdatasystems.com">scott@logicdatasystems.com</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">The lookup sytax is this:<br>
<br>
lookup ("employees@"{company{"")<br>
<br>
<br>
<br>
<br>
<br>
On 4/6/2014 3:01 PM, James Flanagan wrote:<br>
<blockquote type="cite">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.<br>
<br>
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.<br>
<br>
lets say i have the following qualified files:<br>
<br>
employees@google<br>
employees@yahoo<br>
employees@fptech<br>
<br>
and just to keep the code super simple, i have the
following code:<br>
<br>
::declare local company:<br>
::company=“google”:<br>
::lookup employees@(company) k=(aa) i=a -nx:<br>
<br>
no matter what i try, it seems to ignore the “(company)”
and treat the lookup as if it is just "employees@“ .<br>
<br>
Please tell me that i am overlooking something. Thank you
very much,<br>
<br>
<br>
<br>
<br>
James Flanagan<br>
<a moz-do-not-send="true" href="http://flantec.com/">Flantec.com</a><br>
<br>
email:<span class="Apple-tab-span" style="white-space:pre">
</span><a class="moz-txt-link-abbreviated" href="mailto:James@Flantec.com">James@Flantec.com</a><br>
mobile:<span class="Apple-tab-span" style="white-space:pre"> </span>760-458-8498<br>
home: <span class="Apple-tab-span" style="white-space:pre"> </span>219-221-6219<br>
text:<span class="Apple-tab-span" style="white-space:pre">
</span><span class="Apple-tab-span" style="white-space:pre"> </span><a class="moz-txt-link-abbreviated" href="mailto:7604588498@txt.att.net">7604588498@txt.att.net</a><br>
<br>
aim:<span class="Apple-tab-span" style="white-space:pre">
</span><span class="Apple-tab-span" style="white-space:pre"> </span>Flantec<br>
oovoo:<span class="Apple-tab-span" style="white-space:pre">
</span>Flantec<br>
Skype:<span class="Apple-tab-span" style="white-space:pre">
</span>Flantec<br>
ichat:<span class="Apple-tab-span" style="white-space:pre">
</span><a class="moz-txt-link-abbreviated" href="mailto:Flantec@mac.com">Flantec@mac.com</a><br>
<br>
home:<span class="Apple-tab-span" style="white-space:pre">
</span>1901 Cidermill Road<br>
<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Michigan
City, IN 46360<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20140406/6cfea42d/attachment.html">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140406/6cfea42d/attachment.html</a><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
<br>
<br>
</blockquote>
<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a moz-do-not-send="true" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</blockquote></div><br></div></body></html>