AREV 2.12 Indexing (AREV Specific)
At 16 OCT 1997 02:55:40PM Paul Gibbs wrote:
We have just upgraded to AREV 2.12 from 1.16. For some reason when an RLIST statment is executed on a date field it will only use indexing if an EQ or=is used. If a from to, or between statement is used it will not use indexing. All date fields are right justified. Anybody have any ideas.
At 16 OCT 1997 03:01PM Aaron Kaplan wrote:
Try adding in the CASEINSENS keyword before the WITH field
SELECT FILE WITH CASEINSENS DATE BETWEEN '12/01/97' AND '12/31/97'
