<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Thank you all very much for your suggestions. you have shown me several ways to accomplish this and as soon as I complete the earlier module (I will be following up with another question for that shortly), I will see which one works best. thanks again….<br class=""><div class="">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 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); " class=""><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); " class=""><span style="text-decoration: underline; " class=""><a href="http://Flantec.com/" class="">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; " class=""><br class=""></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); " class=""><span style="color: rgb(121, 121, 121); " class="">email:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:James@Flantec.com" class=""><span style="text-decoration: underline; color: rgb(0, 106, 227); " class="">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); " class="">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); " class="">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); " class=""><span style="color: rgb(121, 121, 121); " class="">text:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:7604588498@txt.att.net" class=""><span style="text-decoration: underline; color: rgb(0, 106, 227); " class="">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; " class=""><br class=""></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); " class="">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); " class="">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); " class="">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); " class=""><span style="color: rgb(121, 121, 121); " class="">ichat:<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:Flantec@mac.com" class=""><span style="text-decoration: underline; color: rgb(0, 106, 227); " class="">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; " class=""><br class=""></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); " class="">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); " class=""><span class="Apple-tab-span" style="white-space: pre; "> </span>Michigan City, IN 46360</div></span>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On Apr 8, 2015, at 7:59 AM, Jay Ashworth <<a href="mailto:jra@baylink.com" class="">jra@baylink.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">And yes, I meant 'idempotant', not 'atomic'. :-)<br class=""><br class="">On April 7, 2015 5:46:42 PM EDT, Kenneth Brody <<a href="mailto:kenbrody@spamcop.net" class="">kenbrody@spamcop.net</a>> wrote:<br class=""><blockquote type="cite" class="">On 4/7/2015 4:44 PM, Jay Ashworth wrote:<br class=""><blockquote type="cite" class="">As your single -r parameter, send<br class=""><br class="">KEY1|KEY2|KEY3|ETC<br class=""><br class="">And in the -v table, do<br class=""><br class="">IF @PM co "|"{keyfield SELECT<br class="">IF @PM co KEYFIELD{"|" SELECT<br class=""></blockquote><br class="">I believe you mean:<br class=""><br class=""> @PM co "|"{keyfield{"|"<br class=""><br class="">And you need to start and end your parameter value with "|" as well. <br class="">Otherwise, using your example, "KEY" and "Y2" would both match your<br class="">code.<br class=""><br class="">[...]<br class=""><blockquote type="cite" class="">But multiple SELECTS in one record are atomic, I think.<br class=""></blockquote>[...]<br class=""><br class="">By that, I assume you mean that executing SELECT more than once on a<br class="">single <br class="">record will only select it once. That is the correct, documented,<br class="">behavior.<br class=""><br class="">-- <br class="">Kenneth Brody<br class=""></blockquote><br class="">-- <br class="">Sent from my Android phone with K-9 Mail. Please excuse my brevity.<br class="">-------------- next part --------------<br class="">An HTML attachment was scrubbed...<br class="">URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20150408/e6d50f7d/attachment.html" class="">http://mailman.celestial.com/pipermail/filepro-list/attachments/20150408/e6d50f7d/attachment.html</a>><br class="">_______________________________________________<br class="">Filepro-list mailing list<br class=""><a href="mailto:Filepro-list@lists.celestial.com" class="">Filepro-list@lists.celestial.com</a><br class="">Subscribe/Unsubscribe/Subscription Changes<br class="">http://mailman.celestial.com/mailman/listinfo/filepro-list<br class=""></div></blockquote></div><br class=""></body></html>