CREATE TABLE tbSwitches AS SELECT * FROM MyDatabase.TB_BranchSwitchs WHERE BranchSysNo = 1 ORDER BY SwitchNo WITH DATA ';

---

 Comments

---

The ORDER BY should not have been allowed in this context. In addition, this also applies to the INSERT statement's SELECT portion when using a sub-query to insert rows from one table to another. Per the release notes:

ORDER BY

As of version 1.06, using an ORDER BY clause with the SELECT portion of an INSERT statement or a CREATE TABLE AS statement will result in a compilation error. The ORDER BY clause in these cases does not have any bearing on the resultant inserted rows or created table and this has caused considerable confusion.

---

 Resolution

---

Fixed Problem on 10/3/2007 in version 1.06 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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial