<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;">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 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 1:31 PM, Scott Nelson <<a 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 href="http://Flantec.com">Flantec.com</a><br><br>email:<span class="Apple-tab-span" style="white-space:pre"> </span>James@Flantec.com<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>7604588498@txt.att.net<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>Flantec@mac.com<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: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140406/6cfea42d/attachment.html<br>_______________________________________________<br>Filepro-list mailing list<br>Filepro-list@lists.celestial.com<br>Subscribe/Unsubscribe/Subscription Changes<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br><br><br></blockquote><br><br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br></blockquote></div><br></div></body></html>