SELECT
File.FileID,
PathDictionary."Path",
FileDictionary."Name",
CompanyDictionary."Name"  Company
FROM File
INNER JOIN  PathDictionary ON
File.PathDictionaryID = PathDictionary.PathDictionaryID
  INNER JOIN FileDictionary ON
File.FileDictionaryID = FileDictionary.FileDictionaryID
  LEFT JOIN CompanyDictionary ON FileDictionary.CompanyDictionaryID = CompanyDictionary.CompanyDictionaryID
WHERE ( NodeId=1 ) AND (File.Deleted = false) AND
   (File.UserActivity = false)
ORDER BY FileDictionary."Name"

---

 Comments

---

The problem was caused by very large index keys in the ORDER BY that EDB wasn't handling properly in the result set sorting.

---

 Resolution

---

Fixed Problem on 2/15/2010 in version 2.03 build 9

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial