Building a selection set on the fly
Shane Gray
fplist at satsof.com.au
Wed Feb 23 18:31:35 PST 2005
> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Don
> Coleman
> Sent: Thursday, 24 February 2005 2:03
> To: filePro List
> Subject: Building a selection set on the fly
>
>
> List:
>
> I use the code posted below to build a small 3 line selection set on the
> fly. Now, for one customer, my client needs me to add a fourth
> selection criteria. On the line
> if 9 eq "MTSP
> then goto montana
> *report errors out on the write use;close use located on line #30. Can
> anyone see what I am doing wrong on lines 27-28 that is causing this
> problem? The only difference is when filling in the use(5) field. I
> manually set up the selection set and opened it with a text editor and
> it looks as I would expect it to look. It passes the syntax check but
> errors out at run-time with a memory error on multiple PC's. If field 9
> ne "MTSP" the program still functions fine. fPv5.0.13 on Win98SE and XP
> Pro clients, Win2000 Advanced Server. The sample code below is from the
> -v (select) process.
>
>
> 19 ------- - - - - - - - - - - - - - - - -
> noctl If:
> Then: RF="E:\QS1\TODO\FILEPRO\QS1\DOUBLE.SEL"{""
> 20 ------- - - - - - - - - - - - - - - - -
> If:
> Then: 'RF="C:\RXPRISON\FILEPRO\QS1\DOUBLE.SEL"{""
> 21 ------- - - - - - - - - - - - - - - - -
> If: 9 eq "MTSP"
> Then: goto montana
> 22 ------- - - - - - - - - - - - - - - - -
> If:
> Then: export ascii use=(RF) f=\n
> 23 ------- - - - - - - - - - - - - - - - -
> If:
> Then: use(1)="";use(2)=":9:eq:"{AB;use(3)=":150:eq:"{"Y"
> 24 ------- - - - - - - - - - - - - - - - -
> If:
> Then:
> use(4)=":66:eq:"{@td;use(5)="";use(6)=":::";use(7)=":::";use(8)="::
> :";use(9)=":::"
> 25 ------- - - - - - - - - - - - - - - - -
> If:
> Then:
> use(10)=":::";use(11)=":::";use(12)=":::";use(13)=":::";use(14)="
> ";goto finsel
> 26 ------- - - - - - - - - - - - - - - - -
> montana If:
> Then: use(1)="";use(2)=":9:eq:"{AB;use(3)=":150:eq:"{"Y"
> 27 ------- - - - - - - - - - - - - - - - -
> If: AC eq "A"
> Then:
> use(4)=":66:eq:"{@td;use(5)=":4:eq:"{"JBP";use(6)=":::";use(7)=":::
> ";use(8)=":::";use(9)=":::"
> 28 ------- - - - - - - - - - - - - - - - -
> If: AC eq "D"
> Then:
> use(4)=":66:eq:"{@td;use(5)=":4:ne:"{"JBP";use(6)=":::";use(7)=":::
> ";use(8)=":::";use(9)=":::"
> 29 ------- - - - - - - - - - - - - - - - -
> If:
> Then:
> use(10)=":::";use(11)=":::";use(12)=":::";use(13)=":::";use(14)="
> "
> 30 ------- - - - - - - - - - - - - - - - -
> finsel If:
> Then: write use;close use
>
Because you never execute the export command if 9 eq "MTSP" ?????
More information about the Filepro-list
mailing list