ALTER TABLE "TB_Users" ADD COLUMN SkinIndex Integer DEFAULT 0 AT 0;

---

 Comments and Workarounds

---

ElevateDB was allowing the 0 position and not adjusting it to 1, and this caused it to use the internal RowID column instead of the desired column. The column positions are 1-based, and the workaround to the issue is to make sure that you use 1 instead of 0 for the first column. With the fix, any time a position less than 1 is specified, it is automatically adjusted to 1 and inserted at that position.

---

 Resolution

---

Fixed Problem on 7/21/2007 in version 1.05 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