View Incident Report

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 and Workarounds

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

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap