selection set never ends

[Dennis Malen]

----- Original Message ----- 
From: "GCC Consulting" <gccconsulting at comcast.net>
To: "'Dennis Malen'" <dmalen at malen.com>; <filepro-list at lists.celestial.com>
Sent: Thursday, June 01, 2006 4:37 PM
Subject: RE: selection set never ends


>
>
>> -----Original Message-----
>> From: filepro-list-bounces at lists.celestial.com
>> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf
>> Of Dennis Malen
>> Sent: Thursday, June 01, 2006 4:30 PM
>> To: filepro-list at lists.celestial.com
>> Subject: selection set never ends
>>
>> The following is a selection set that I am trying to use.
>> When I attempt to use it to run a report it continues showing
>> the selection of records above that which is in the file and
>> the counter on the screen shows that it is selecting
>> additional records (more than what it should be). I then
>> break out. I know that it is more than it should be because I
>> run the selection set in IUA. When in this environment the
>> search stops at the last record but never shows the "End of
>> File". It just hangs there.
>>
>>         ~  68 ~ Closed Status            eq  ~     ~
>>         ~  93 ~ p1)M: HA Phone       eq      ~   ~
>>         ~  94 ~ p1)CM: HA Phone     eq       ~   ~
>>         ~  95 ~ p1)M: POB Phone       eq     ~    ~
>>         ~  96 ~ p1)CM: POB Phone      eq     ~   ~
>>         ~  64 ~ Payer Dept (Col,Leg Pa     eq~   c ~
>>  c      ~  9  ~ Collector                  eq~   55~
>>  c      ~  9  ~ Collector                  eq~   57~
>>  c      ~  9  ~ Collector                  eq~   59~
>>  c      ~  85 ~ Coll Code:CoMaker         eq ~   55~
>>  c      ~  85 ~ Coll Code:CoMaker          eq~   57~
>>  c      ~  85 ~ Coll Code:CoMaker          eq~   59~
>>
>> Is there something wrong with my selection set?
>>
>> Dennis Malen
>> 516.479.5912
>>
> Dennis,
>
> Since you have the phone # as associated fields, why not just use
> The associated field value.  That is, of course, assuming that there are 
> no
> more phone # fields in this association.
>
>
>        ~  68 ~ Closed Status               eq~     ~
>         ~  p1 ~ p1)M: HA Phone             eq~     ~
>         ~  64 ~ Payer Dept (Col,Leg Pa     eq~   c ~
>  c      ~  9  ~ Collector                  eq~   55~
>  c      ~  9  ~ Collector                  eq~   57~
>  c      ~  9  ~ Collector                  eq~   59~
>  c      ~  85 ~ Coll Code:CoMaker          eq~   55~
>  c      ~  85 ~ Coll Code:CoMaker          eq~   57~
>  c      ~  85 ~ Coll Code:CoMaker          eq~   59~
>
> Your record cound may be affected by the associated fields.
>
Richard,

That was the way I first did it. What you have below is my alternative 
approach which was not any more successful.

Dennis
> Richard Kreiss
> GCC Consulting
>
>
>
>
>
>