Arev32 Select Issue with Right Justified Date Fields (Functions/Subroutines/Programs,General) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Arev32 Select Issue with Right Justified Date Fields (Functions/Subroutines/Programs,General) ======

======   ======

==== Created at 02 OCT 2017 01:28PM ====




Arev32 Select Issue with Right Justified Date Fields




There is an issue in Arev32 when selecting or listing date fields that are right justified.  If the environment is set to NO on "Ignore case in R/LIST queries (Y/N)" and the date field is right justified then the selection of dates will be inaccurate when selecting between or greater than or equal to.




To resolve this issue modify the environment  to YES on "Ignore case in R/LIST queries (Y/N)".




{{kb1071_1.png}}




To access the environment record hit F5 to get to TCL and type RUNMENU APPMAIN.  Select UTILITIES, CONFIGURE, ENVIROMMENT, QUERY, QUERY PROCESS.




{{kb1071_2.png}}