selection set never ends

[GCC Consulting]

> -----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 Kreiss
GCC Consulting