{{tag>category:"AREV Specific"}}

[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== AREV 2.12 Indexing (AREV Specific) ====
=== At 16 OCT 1997 02:55:40PM Paul Gibbs wrote: ===
 
 
<QUOTE>
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.
</QUOTE>
----

=== At 16 OCT 1997 03:01PM Aaron Kaplan wrote:  ===

<QUOTE>Try adding in the CASEINSENS keyword before the WITH field


<code>
SELECT FILE WITH CASEINSENS DATE BETWEEN '12/01/97' AND '12/31/97'
</code>










apk@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura Ltd[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8401B36417083468852565320067F95A|View this thread on the  forum...]]