3.12 Wierd Indexing Problem (AREV Specific)
At 31 AUG 2001 02:36:21AM Curt Putnam wrote:
I deleted all indexing on the file and deleted flags in the Dict. Exited Arev and renamed the data volume via namevolume. Fired up arev and recreated the index.
This syntax produces 10 extra records - which do not exist in the data:
Select Sales (with SaleDate ⇐ "08/30/01") AND (with Saledate ⇐ "08/31/01")
The "extra" ids are 0 - 9
The BETWEEN syntax works correctly.
No system delimiters in the IDs. IDs are sequential integers.
Any clues?
TIA, Curt
At 31 AUG 2001 04:43AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Curt,
You've probably already considered this, but FWIW
Take the curved brackets out of your statement.
Check the Input formats (ICONVs) on the saledate field are correctly set.
Check for records with null saledates in them.
You may have replaced the BTREE but is there a quickdex on the file as well?
The syntax of your statement looks a little unusual. Why are both comparisons less than or equal to The Sprezzatura Group[/url]
World Leaders in all things RevSoft
At 01 SEP 2001 03:34PM Curt Putnam wrote:
The syntax looks wierd because it's a typo
At 04 SEP 2001 12:17PM Jim Jefferson wrote:
Sorry that I can't help with this other than to report that we have the same problem exhibited here (3.12). There appears to be a problem with ]= " or "GE" used on indexed date fields. I think the same problem exists with "⇐ and "LE" but can't recall.