Building a selection set on the fly
Nancy Palmquist
nlp at vss3.com
Wed Feb 23 09:51:51 PST 2005
Don Coleman wrote:
> 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 ------- - - - - - - -
On a selection table you do not enter quotes. You just need to put JBP.
If you want quotes, you type \"JBP\"
- - - - - - - - -
> If:
> Then:
> use(10)=":::";use(11)=":::";use(12)=":::";use(13)=":::";use(14)="
> "
> 30 ------- - - - - - - - - - - - - - - - -
> finsel If:
> Then: write use;close use
>
> Thanks,
>
> Don Coleman
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
More information about the Filepro-list
mailing list