<html><head></head><body>There's only ten records in each of the files. I number them 0-9 for the dept or class assignment. I'll add a default if it somehow fails the dept or class lookup but there's checks before saving an inventory record and you couldn't save unless the dept and class are currently assigned. <br clear="none">
<br clear="none">
I just don't get is why it works without the -ro flag and not with it but somethings definitely going on when I see the processing slowing down and then ultimately stopping when I try to use it. <br clear="none">
<br clear="none">
Mike <br clear="none"><br clear="none"><div class="gmail_quote">On Aug 3, 2014, "Richard D. Williams" <richard@appgrp.net> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k10mail">Mike,<br clear="none"><br clear="none">I do not know your data situations, but the first thing I see is you do <br clear="none">not have any option if<br clear="none">your "dept" or "class" lookups fail.<br clear="none"><br clear="none">If for some reason you have data that is not a match in one of these <br clear="none">instants, your program has not where to go.<br clear="none"><br clear="none">Try this approach:<br clear="none"><br clear="none">10 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: lookup dept k=22 i=A -nx<br clear="none">11 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: dept<br clear="none">Then: dp(15,*,g)=dept(2)<br clear="none">12 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: lookup class k=23 i=A -nx<br clear="none">13 ------- - - - - -
- -
- - - - - - - - -<br clear="none">? If: class<br clear="none">Then: cl(15,*,g)=class(2)<br clear="none">14 ------- - - - - - - - - - - - - - - - -<br clear="none"><br clear="none"><br clear="none">Then simply review to see if you are missing the expected values for <br clear="none">"dp" and/or "cl".<br clear="none"><br clear="none">Richard<br clear="none"><br clear="none">On 8/3/2014 1:33 PM, Mike Fedkiw wrote:<br clear="none"></pre><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">Although it's kind of a long post, this is the exact processing table<br clear="none">that stops running when I use the -RO flag<br clear="none"><br clear="none">Mike<br clear="none"><br clear="none"><br clear="none">1 ------- - - - - - - - - - - - - - - - -<br clear="none">start ? If:<br clear="none">Then: kn="";wa=""<br clear="none">2 ------- - -
- -
- - - - - - - - - - - -<br clear="none">? If: 118 eq "y"<br clear="none">Then: end<br clear="none">3 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 77 eq "y"<br clear="none">Then: end<br clear="none">4 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 47 eq ""<br clear="none">Then: end<br clear="none">5 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: oh(6,.0,g)=97<br clear="none">6 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: oh lt "0"<br clear="none">Then: oh="0"<br clear="none">7 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: (6 gt "") and (7 gt "") and (8 gt "") and (9 gt "")<br clear="none">Then: ua(15,*,g)=6&"-"&7&"-"&8&"-"&9<br clear="none">8 ------- - - - - - - -
- -
- - - - - - -<br clear="none">? If: '(6 gt "") and (7 gt "") and (8 gt "") and (9 gt "")<br clear="none">Then: 'ub(12,*,g)=6&7&8&9<br clear="none">9 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: '(7 gt "") and (8 gt "")<br clear="none">Then: 'uc(10,*,g)=7&"-"&8<br clear="none">10 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: lookup dept k=22 i=A -nx<br clear="none">11 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: dp(15,*,g)=dept(2)<br clear="none">12 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: lookup class k=23 i=A -nx<br clear="none">13 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: cl(15,*,g)=class(2)<br clear="none">14
------- - - - - - - - - - - - - - - - -<br clear="none">? If: sn eq "0"<br clear="none">Then: sn(9,*,g)=""<br clear="none">15 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: sn=18<br clear="none">16 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: hl="";qt=chr("34")<br clear="none">17 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: im=qt{"Image"{qt<br clear="none">18 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 73 eq "u"<br clear="none">Then: in(30,alldn,g)=4&"/"&4&"_"{8{".jpg"<br clear="none">19 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 73 eq "u"<br clear="none">Then: hl="<a shape="rect"
href="http://fedko.biz/v500/Images">http://fedko.biz/v500/Images</a>/"{in<br clear="none">20 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 73 eq "m"<br clear="none">Then: in=4&"/"&4&"_"{15{".jpg"<br clear="none">21 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 73 eq "m"<br clear="none">Then: hl="<a shape="rect" href="http://fedko.biz/v500/Images">http://fedko.biz/v500/Images</a>/"{in<br clear="none">22 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 73 eq "s"<br clear="none">Then: in=4&"/"&4&"_"{18{".jpg"<br clear="none">23 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: 73 eq "s"<br clear="none">Then: hl="<a shape="rect" href="http://fedko.biz/v500/Images">http://fedko.biz/v500/Images</a>/"{in<br clear="none">24 ------- - - - - - - - - - - - -
- - -
-<br clear="none">? If: 73 eq ""<br clear="none">Then: hl=""<br clear="none">25 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: gosub getvend<br clear="none">26 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: export multi invfile=c:\export\invyfile.slk<br clear="none">27 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: xx eq ""<br clear="none">Then: gosub once;xx(1,*,g)="y";goto start<br clear="none">28 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(1)=3<br clear="none">29 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(2)=4<br clear="none">30 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">
Then:
invfile(3)=kn<br clear="none">31 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(4)=wa<br clear="none">32 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(5)=1<br clear="none">33 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(6)=16<br clear="none">34 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(7)=34<br clear="none">35 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(8)=dp<br clear="none">36 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(9)=cl<br clear="none">37 ------- - - - - - - - - - - - - - - - -
<br
clear="none">? If:<br clear="none">Then: invfile(10)=8 'upc 5<br clear="none">38 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(11)=7&8 'upc 10<br clear="none">39 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(12)=6&7&8&9 'upc 12<br clear="none">40 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(13)=ua 'upc edit<br clear="none">41 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(14)=15<br clear="none">42 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(15)=sn<br clear="none">43 ------- - - - - - - - - - - - - - - - -<br clear="none">? I
f:<br
clear="none">Then: invfile(16)=28<br clear="none">44 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(17)=32<br clear="none">45 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(18)=47<br clear="none">46 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(19)=57<br clear="none">47 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(20)=61<br clear="none">48 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(21)=65<br clear="none">49 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(22)=69<br clear="none">50 ------- - - - - - - - -
- -
- - - - - -<br clear="none">? If:<br clear="none">Then: invfile(23)=36<br clear="none">51 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(24)=oh<br clear="none">52 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(25)=hl<br clear="none">53 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: end<br clear="none">54 ------- - - - - - - - - - - - - - - - -<br clear="none">once ? If:<br clear="none">Then: invfile(1)="Vend_Internal"<br clear="none">55 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(2)="Vend_Code"<br clear="none">56 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then:
invfile(3)="Vend_Key_Name"<br clear="none">57 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(4)="Vend_Web_Add"<br clear="none">58 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(5)="PN_Internal"<br clear="none">59 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(6)="Fedko_No"<br clear="none">60 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(7)="U/M"<br clear="none">61 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(8)="Dept"<br clear="none">62 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(9)="Class"<br clear="none">63 ------- -
- -
- - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(10)="UPC_5"<br clear="none">64 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(11)="UPC_10"<br clear="none">65 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(12)="UPC_12"<br clear="none">66 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(13)="UPC_Edit"<br clear="none">67 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(14)="Mfg_No"<br clear="none">68 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(15)="Sap_No"<br clear="none">69 ------- - - - - - - - - - - - - - - - -<br
clear="none">? If:<br clear="none">Then: invfile(16)="Description"<br clear="none">70 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(17)="Net_Item"<br clear="none">71 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(18)="List_Sell"<br clear="none">72 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(19)="Price_A"<br clear="none">73 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(20)="Price_B"<br clear="none">74 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(21)="Price_C"<br clear="none">75 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then:
invfile(22)="Price_D"<br clear="none">76 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(23)="Sell_Mult"<br clear="none">77 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(24)="On_Hand"<br clear="none">78 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: invfile(25)="Image_link"<br clear="none">79 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: return<br clear="none">80 ------- - - - - - - - - - - - - - - - -<br clear="none">getvend? If:<br clear="none">Then: lookup vend k=3 i=A -nx<br clear="none">81 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: not vend<br clear="none">Then: return<br clear="none">82 ------- - -
-
- - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: kn=vend(11)<br clear="none">83 ------- - - - - - - - - - - - - - - - -<br clear="none">? If: vend(37) gt ""<br clear="none">Then: wa=vend(37)<br clear="none">84 ------- - - - - - - - - - - - - - - - -<br clear="none">? If:<br clear="none">Then: return<br clear="none"><br clear="none"><br clear="none">On 8/1/2014 10:23 AM, Kenneth Brody wrote:<br clear="none"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;">On 7/31/2014 7:02 PM, FilePro List wrote:<br clear="none">[...]<br clear="none"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;">Anyhow, I changed the output line to say this and it took a whole three<br clear="none">seconds to run through every record without any issues.<br clear="none"
><br
clear="none">\fp\dreport invy -f expIslk -y none -z none -a -u -ro<br clear="none"><br clear="none"><br clear="none">There's not much processing going on here and without the -ro flag it<br clear="none">only takes about 15 seconds to run<br clear="none"></blockquote>[...]<br clear="none"><br clear="none">Well, if it runs in only 3 seconds w/o processing, but runs slower and<br clear="none">slower (until it eventually "stops altogether") with processing, then<br clear="none">it's obviously something in the processing that's doing it.<br clear="none"><br clear="none">You say "not much processing", but you don't tell us what it is, so we<br clear="none">can't even venture a guess beyond "there's *something* in the<br clear="none">processing that's causing it".<br clear="none"><br clear="none">P.S. Could you please change your e-mail user name from "FilePro List"<br clear="none">to something more meaningful for the rest of us?</blockquote><br clear="none"><hr><br
clear="none">Filepro-list mailing list<br clear="none">Filepro-list@lists.celestial.com<br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a></blockquote><br clear="none"><br clear="none"><br clear="none"><br clear="none"></blockquote></div><br clear="none">-- Sent with <b><a shape="rect" href="https://play.google.com/store/apps/details?id=com.onegravity.k10.pro2">K-@ Mail</a></b> - the evolution of emailing.</body></html>