CREATE TABLE "NotasCli"
(
"NumCliente" INTEGER NOT NULL,
"Data" DATE NOT NULL,
"CriadoPor" VARCHAR(16) COLLATE "PTG_CI" NOT NULL,
"Assunto" VARCHAR(50) COLLATE "PTG",
"Cor" INTEGER,
"Arquivar" BOOLEAN,
"AlteradoPor" VARCHAR(16) COLLATE "PTG_CI",
"CriadoEm" TIMESTAMP,
"AlteradoEm" TIMESTAMP,
"Texto" CLOB COLLATE "PTG",
"Agendar" BOOLEAN,
"AgData" DATE,
"AgHora" TIME,
"AgConcluido" BOOLEAN,
"AgTodos" BOOLEAN,
"Delegacao" INTEGER DEFAULT 0  NOT NULL
)

---

 Comments

---

The problem was caused by the ODBC client version not being transmitted properly to the ElevateDB Server, thus resulting in the server sending back incorrect information in the result sets for catalog queries on the table columns.

---

 Resolution

---

Fixed Problem on 2/28/2009 in version 2.02 build 9

---

 Products Affected

---

ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial