<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Forwarded to fp list<BR><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Forwarded Message ----<BR>From: Richard Hane <yoresoft@sbcglobal.net><BR>To: Nancy Palmquist <nlp@vss3.com><BR>Cc: Ray Hoover <rhoover@fptech.com><BR>Sent: Thursday, May 15, 2008 9:39:59 AM<BR>Subject: Re: Memory change in 5.0.15<BR><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">[ Sorry for the top post ]</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Nancy, Thanks for the idea but that did not work. </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Ray, no the dif file is not bad.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Here is what I found. If the Excel dif file has more than 40K rows it does not work. It goes through the file but gets no data (Won't even display it with a show statement). This has happened on 3 of the dif files I import. All others are under 30K rows and work fine.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Now I have made a work around. Using selection criteria in the Excel querry (odbc from an SQL file) I am able to limit the records select to keep all rows on all dif files under 35K. Tested and all worked correctly.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">BTW.. I checked the available memory while running one of these processes and I still had 166 mb free.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">I would like to find out what is causing this but I am functional (insert joke here) at this point.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Thank you,</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Rick Hane</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Controller</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Deluxe Stitcher Company Inc</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><A href="http://www.deluxestitcher.com/" target=_blank rel=nofollow>www.deluxestitcher.com</A></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Nancy Palmquist <nlp@vss3.com><BR>To: Richard Hane <yoresoft@sbcglobal.net><BR>Cc: filepro-list@lists.celestial.com<BR>Sent: Wednesday, May 14, 2008 2:14:38 PM<BR>Subject: Re: Memory change in 5.0.15<BR><BR>Richard Hane wrote:<BR>> Ray,<BR>> <BR>> Here is the batch file that is used.<BR>> <BR>> set PFDSK=V<BR>> set PFPROG=V:<BR>> set PFDATA=V:<BR>> set PFDIR=<BR>> set PFCMARK=20<BR>> set PFLMHOST=server2007<BR>> cd fp<BR>> dprodir bom -ka<BR>> rreport acttime -f getbom -s one<BR>> cd\<BR>> cls<BR>> Note: dirve V: is mapped to \\server2007\F\fpodbc <BR>> <file://\\server2007\F\fpodbc><BR>> The batch file resides in the fpodbc and the bom.dif resides in \fp folder<BR>> <BR>> There is one other dif file that has more rows but I hav not checked
it <BR>> yet. I will do so tonight and advise.<BR>> <BR>> The process runs one 1 record in a file called acttime (which is where I <BR>> run all my import processes).<BR>> <BR>> Here is the process...<BR>> 1 (label) = getit Then: import dif fpo = bom<BR>> 2. If: not fpo Then: end<BR>> 3. Then: a(20,*);q(9,.4);d(10,mdyy/);b(20,*)<BR>> 4. Then: q=fpo(3); b=fpo(2); a=fpo(1); d=fpo(4)<BR>> 5. Then: np(5,.0)=np+"1"<BR>> 6. Then: show ("7","10") "processing part number"<a<BR>> 7. Then: show ("9","10") "no. of parts"<np<BR>> 8. Then: lookup miv = bom r=free -n<BR>> 9. If: not miv Then: errorbox "Part"<a<"Not Created";end<BR>> 10. Then: miv(1)=a;miv(2)=b;miv(3)=q;miv(4)=d<BR>> 11. Then write miv<BR>> 12. Then: goto getit<BR>> 13: Then: end<BR>> <BR>> When the process does not run correctly it creates 47k blank records.<BR>>
<BR>> Thanks<BR>> Rick<BR>> <BR>> <BR>> <BR><BR>Rick,<BR><BR>Try:<BR><BR>PFIMPBUF= 65536<BR><BR>to increase the maximum record length to 65K for an imported record.<BR><BR>Nancy<BR><BR><BR><BR><BR>-- <BR>Nancy Palmquist MOS & filePro Training Available<BR>Virtual Software Systems Web Based Training and Consulting <BR>PHONE: (412) 835-9417 Web site: <A href="http://www.vss3.com/" target=_blank rel=nofollow>http://www.vss3.com</A><BR></DIV></DIV></DIV></DIV></DIV></div></body></html>