<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
The -RO just wont work. I just did a simple test as you see below
and it still freezes up. I did try adding a "close disc" after and
that seemed to let it get through all the records but when I added
the close to my other processing it still didn't get through all the
records. <br>
<br>
I suppose I could do a lookup from another file and fill in a bunch
of variables for the export but it would be so much easier if the
-RO would just freaking work. <br>
<br>
I also re-indexed all the files involved and that made no difference
at all<br>
<br>
this is the command line that I am using<br>
\fp\dreport invy -f expIslk2 -a -u -ro<br>
<br>
<br>
<br>
<br>
1 ------- - - - - - - - - -<br>
◄ If:<br>
Then: dn="1"<br>
2 ------- - - - - - - - - -<br>
◄ If:<br>
Then: lookup dept k=dn i=A -nxp >>>> tried this
with and without the "P" and made no difference<br>
3 ------- - - - - - - - - -
<br>
◄ If:<br>
Then: end<br>
<br>
<br>
Mike Fedkiw<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 8/4/2014 10:00 AM, Richard D.
Williams wrote:<br>
</div>
<blockquote cite="mid:53DF920D.3080907@appgrp.net" type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<div class="moz-cite-prefix">Mike,<br>
<br>
I do not use the -RO very much.<br>
<br>
Try using the -nxp to your lookups.<br>
Perhaps FP is think you are about to update data in another
file.<br>
<br>
You are going directly at the file that about this inventory
quan..<br>
Trying using a dummy file, add a single record, do a lookup to
the target file , and then write the export.<br>
You can do this using dclerk instead of dreport.<br>
<br>
Look at the @menu command.<br>
<br>
Richard<br>
<br>
On 8/3/2014 7:47 PM, Mike Fedkiw wrote:<br>
</div>
<blockquote
cite="mid:a29bbbe6-a57b-4499-aec7-ee78ce54c65f@aol.com"
type="cite">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" <a
moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="mailto:richard@appgrp.net"><richard@appgrp.net></a>
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,
I do not know your data situations, but the first thing I see is you do
not have any option if
your "dept" or "class" lookups fail.
If for some reason you have data that is not a match in one of these
instants, your program has not where to go.
Try this approach:
10 ------- - - - - - - - - - - - - - - - -
? If:
Then: lookup dept k=22 i=A -nx
11 ------- - - - - - - - - - - - - - - - -
? If: dept
Then: dp(15,*,g)=dept(2)
12 ------- - - - - - - - - - - - - - - - -
? If:
Then: lookup class k=23 i=A -nx
13 ------- - - - - -
- -
- - - - - - - - -
? If: class
Then: cl(15,*,g)=class(2)
14 ------- - - - - - - - - - - - - - - - -
Then simply review to see if you are missing the expected values for
"dp" and/or "cl".
Richard
On 8/3/2014 1:33 PM, Mike Fedkiw wrote:
</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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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">
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br
clear="none">
Subscribe/Unsubscribe/Subscription Changes<br clear="none">
<a moz-do-not-send="true" 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 moz-do-not-send="true" shape="rect"
href="https://play.google.com/store/apps/details?id=com.onegravity.k10.pro2">K-@
Mail</a></b> - the evolution of emailing. </blockquote>
<br>
</blockquote>
<br>
</body>
</html>