Icon View Incident Report

Serious Serious
Reported By: Felix Gartsman
Reported On: 7/20/1999
For: Version 1.15 Build 1
# 462 Using INTO Clause With SQL Queries Results in Table in Wrong Primary Index Order

Another issue is not saving the data correctly:

SELECT LanguageID, LanguageText
Into TempLang
From Languages
ORDER BY LanguageText DESC

LanguageId - AutoInc
LanguageText - String[20]

The data saved like the sort is ASC and not Desc.

Comments Comments and Workarounds
Changing the active index to the index named ORDER BY would solve the problem, but this has been changed in 1.16 so that this is not necessary.

Resolution Resolution
Fixed Problem on 7/23/1999 in version 1.16 build 1