Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 8/31/2000
For: Version 2.03 Build 1
# 617 Live Queries Not Being Allowed if SQL ORDER BY Clause Specifies Integer Fields of Available CI Index

Using a simple SELECT * FROM MyTable ORDER BY MyField when there is a case-insensitive index that begins with the MyField integer field will cause a canned result set even if RequestLive is set to True.

Comments Comments and Workarounds
The workaround is to use the NOCASE keyword after the ORDER BY.

Resolution Resolution
Fixed Problem on 8/31/2000 in version 2.04 build 1