Need code assistance (export from yesterday)
Brian K. White
brian at aljex.com
Tue Jan 18 12:34:33 PST 2005
----- Original Message -----
From: "Matthew Williams" <matthew.d.williams at gmail.com>
To: "FilePro Mailing List" <filepro-list at lists.celestial.com>
Sent: Tuesday, January 18, 2005 3:08 PM
Subject: Re: Need code assistance (export from yesterday)
> Brian, thanks for the update, I did manage to get things working,
> however I just noticed my output included only the first record for
> each RepCode, some have dozens a records, this code only picks up the
> first record then moves on to the next RepCode and so on and so forth.
>
> I guess i'm a little confused now!
>
>
> ------- - - - - - - - - - - - - - - - -
> If: rc ne 1 or rc ne ""
> Then: close rep
>
> ------- - - - - - - - - - - - - - - - -
> If: rc ne 1 or rc ne ""
> Then: rc(3,*,g)=1 ; of = "/upss/invoices/"{1{".txt"; gosub exp
>
> ------- - - - - - - - - - - - - - - - -
> If:
> Then: rep(1)=1;rep(2)=2;rep(3)=3;rep(4)=4;rep(5)=5;rep(6)=6;rep(7)=7
> .... end
>
>
> ------- - - - - - - - - - - - - - - - -
> exp If:
> Then: export word rep = (of) -r=\n -f=,
>
> ------- - - - - - - - - - - - - - - - -
> If: ' Export file header
> Then:
> rep(1)="SalesPerson";rep(2)="OrderNumber";rep(3)="AccountNumber";
> write; return
>
> I will try to go through your email again and see what I can do, i'm
> guessing its one of those IF statements you said I shouldn't have
> thats preventing it from processing all the records? Right now I'm
> getting the output I want, <repcode>.txt but with only a single
> record.
>
> Thanks again!
> -Matt
Yep. Just walk through it.
Just copy it and replace lines 4-18 with your own really.
Brian K. White -- brian at aljex.com -- http://www.aljex.com/bkw/
+++++[>+++[>+++++>+++++++<<-]<-]>>+.>.+++++.+++++++.-.[>+<---]>++.
filePro BBx Linux SCO Prosper/FACTS AutoCAD #callahans Satriani
More information about the Filepro-list
mailing list