"Jack Marsh" <jack@marshdata.co.uk> wrote in message
news:67195A6D-DBC0-49C6-9898-30F709B71616@news.elevatesoft.com...
>
> Many of the groups will have very few members and I had hoped that DBISAM
> would be able to use an index on the GroupCode column to:
>

I'm not 100% sure, but I think if you just add a 'WHERE code in (7,8,10)'
clause to my query, you will filter using the index. Or, run it as a script,
select the two fields "where code in 7 8 10" into a memory table, then run
the previous query.

Robert

"Robert" <rkaplan@AdvantSoft.com> wrote in message
news:A42AC595-996A-4C03-8106-F99E406DE108@news.elevatesoft.com...
>
> select the two fields "where code in 7 8 10" into a memory table, then run
> the previous query.
>
using the memory table as the source (in case it was not clear)

R

Thanks to all - it was great to see the different solutions and has shown
some good basic methods to get me started.

One last note for future reference - was my original syntax correct as Ole
suggested?

Thanks
Jack

Jack,

<< I tried the following as I assumed the query would first generate the
list of contacts in both 7 & 8 and then remove those in 10, but this doesn't
seem to work. >>

The syntax is correct, but DBISAM is executing the set operations out of
order.  It is executing the EXCEPT first, and then the INTERSECT, hence the
incorrect results.  A fix will be in a new build next week.

--
Tim Young
Elevate Software
www.elevatesoft.com

That's good news - thanks Tim

Jack


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:16A4BE5D-8364-41AB-AD78-78D8A396C85B@news.elevatesoft.com...
> Jack,
>
> << I tried the following as I assumed the query would first generate the
> list of contacts in both 7 & 8 and then remove those in 10, but this
> doesn't seem to work. >>
>
> The syntax is correct, but DBISAM is executing the set operations out of
> order.  It is executing the EXCEPT first, and then the INTERSECT, hence
> the incorrect results.  A fix will be in a new build next week.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>