TMG-L Archives
Archiver > TMG > 2005-09 > 1125712690
From: "Jill Morelli" <>
Subject: RE: [TMG] FW: filter help for folks immigrating but with no immigration/emigration tag
Date: Fri, 2 Sep 2005 21:58:10 -0400
In-Reply-To: <6.2.3.4.2.20050902083334.0310e008@popd.ix.netcom.com>
I'll give both your ideas a try (running them separately and doing
VFI/Optimize). I have a lot of immigrants/emigrants in my data base because
I use both tags....one for leaving and one for arriving.
Anyone else have any other ideas?
Jill
-----Original Message-----
From: Dennis Lee Bieber [mailto:]
Sent: Friday, September 02, 2005 11:40 AM
To:
Subject: RE: [TMG] FW: filter help for folks immigrating but with no
immigration/emigration tag
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/>; <
==== TMG Mailing List ====
TMG v6.02 has been released. Check the Wholly Genes web site
<http://www.whollygenes.com>; for more information.
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/88 - Release Date: 9/1/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/88 - Release Date: 9/1/2005
This thread: