This is how to recreate the problem:

(STEP 1): Run the following SQL:

DROP TABLE IF EXISTS "TestForElevate";

CREATE TABLE IF NOT EXISTS "TestForElevate"
(
   "Date Raised" TIMESTAMP,
LANGUAGE "ANSI Standard" SORT "Default Order"
USER MAJOR VERSION 1
);

CREATE DESC INDEX IF NOT EXISTS "Date Raised Desc" ON 
"TestForElevate" 
("Date Raised");


(STEP 2):
Make sure "Want Live Result Set" is checked, and run the following
  select * from TestForElevate order by [Date Raised] desc
Result?  A CANNED result set

(STEP 3):
Use Database System Utility and Restructure the table.  On the 
secondary index 
set CASE-INS to "YES", and SAVE.

(STEP 4):
Go straight back into restructure and set CASE-INS back to "NO" again,
 and 
SAVE, thus apparently giving us exactly the table structure we 
originally set out 
with.

(STEP 5):
Rerun the SQL in STEP 2, and lo and behold, we do NOT get a Canned 
result set 
this time but but a LIVE result set.