Need code assistance (export from yesterday)
Matthew Williams
matthew.d.williams at gmail.com
Tue Jan 18 12:08:47 PST 2005
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!
1 ------- - - - - - - - - - - - - - - - -
If: rc ne 1 or rc ne ""
Then: close rep
2 ------- - - - - - - - - - - - - - - - -
If: rc ne 1 or rc ne ""
Then: rc(3,*,g)=1 ; of = "/upss/invoices/"{1{".txt"; gosub exp
3 ------- - - - - - - - - - - - - - - - -
If:
Then: rep(1)=1;rep(2)=2;rep(3)=3;rep(4)=4;rep(5)=5;rep(6)=6;rep(7)=7
.... end
19 ------- - - - - - - - - - - - - - - - -
exp If:
Then: export word rep = (of) -r=\n -f=,
20 ------- - - - - - - - - - - - - - - - -
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
More information about the Filepro-list
mailing list