Reported By: Ole Willy Tuv Reported On: 8/31/2000 For: Version 2.03 Build 1
# 617Live 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 and WorkaroundsThe workaround is to use the NOCASE keyword after the ORDER BY.
ResolutionFixed Problem on 8/31/2000 in version 2.04 build 1