SELECT
    File.FileID
    FROM
    File
    INNER JOIN  PathDictionary ON File.PathDictionaryID = PathDictionary.PathDictionaryID
    WHERE
    ( File.NodeId=238 )
    AND
    (
      ( File.ApplicationId IS NULL )
    )
    ORDER BY PathDictionary."Path" ;

---

 Comments

---

The problem was related to a bug in the sorting of the result sets for large ORDER BY keys.

---

 Resolution

---

Fixed Problem on 8/6/2009 in version 2.03 build 1

---

 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