TMG-L Archives

Archiver > TMG > 2005-09 > 1125675574


From: Dennis Lee Bieber <>
Subject: RE: [TMG] FW: filter help for folks immigrating but with no immigration/emigration tag
Date: Fri, 02 Sep 2005 08:39:34 -0700
References: <6.2.3.4.2.20050901205018.030db758@popd.ix.netcom.com><200509021116.j82BG5XV021971@ms-smtp-02-eri0.ohiordc.rr.com>
In-Reply-To: <200509021116.j82BG5XV021971@ms-smtp-02-eri0.ohiordc.rr.com>


On or about 9/2/2005 04:13 AM a carrier pigeon from Jill Morelli delivered:

>SINCE I WANTED IT TO BE NEITHER EMIGRATION OR IMMIGRATION, "AND" STILL SEEMS
>LIKE THE RIGHT CONJUNCTION.

Concede...


>THANKS FOR YOUR HELP.

At this point I'd probably have to run each clause
separately to see who appears under them, and work my way up...

I don't recall, but have you run an VFI/Optimize sequence
before running the filter? Possibly some obscure index field has
gotten associated with the wrong data records and is pulling those
instead of the ones you want. Most DBMS algorithms don't look at the
data records if the selection criteria can be found strictly in an
index -- and it would seem that Visual FoxPro is not the most
reliable database when it comes to index maintenance.

--
> ============================================================ <
> | Wulfraed Dennis Lee Bieber KD6MOG <
> | Bestiaria Support Staff <
> ============================================================ <
> Home Page: <http://bieberd.home.netcom.com/>; <


This thread: