View Incident Report

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap