Reported By: Felix Gartsman Reported On: 7/20/1999 For: Version 1.15 Build 1
# 462Using 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 and WorkaroundsChanging 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.
ResolutionFixed Problem on 7/23/1999 in version 1.16 build 1