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