Icon View Incident Report

Serious Serious
Reported By: Adam Brett [Tropical Wholefoods]
Reported On: 3/20/2014
For: Version 2.16 Build 1
# 4017 CreateSQL Columns in System Information Tables Truncated at Last Two Characters

Use of reverse engineer / "create table SQL by dragging" feature of EDBMgr results in flawed SQL.

Open EDbMgr.
Open a DB. Drag any table icon into a new SQL Statement/Script
When requested say "yes"

Resulting SQL looks like the following.

PROBLEMS:

Parentheses not added at end of UID() function call.
Value 0 for default not added.
Default boolean shown as "fal" not "false"

CREATE TABLE "Forecasts"
(
"ID" INTEGER DEFAULT UID NOT NULL,
"LinkTable" VARCHAR(40) COLLATE "ANSI",
"Name" VARCHAR(100) COLLATE "ANSI",
"PeriodTypeID" INTEGER,
"DateTarget" DATE,
"ValueTarget" FLOAT DEFAULT  NOT NULL,
"AcceptableVariance" FLOAT DEFAULT  NOT NULL,
"AuthorID" INTEGER,
"DateCreated" TIMESTAMP DEFAULT Current_Timesta,
"Complete" BOOLEAN DEFAULT fal,
CONSTRAINT "PK_Forecasts" PRIMARY KEY ("ID"),
CONSTRAINT "PeriodTypeID" FOREIGN KEY ("PeriodTypeID") REFERENCES "Types" ("ID")
   ON UPDATE NO ACTION ON DELETE NO ACTION
)


when it should look like this:

CREATE TABLE "Forecasts"
(
"ID" INTEGER DEFAULT UID() NOT NULL,
"LinkTable" VARCHAR(40) COLLATE "ANSI",
"Name" VARCHAR(100) COLLATE "ANSI",
"PeriodTypeID" INTEGER,
"DateTarget" DATE,
"ValueTarget" FLOAT DEFAULT 0 NOT NULL,
"AcceptableVariance" FLOAT DEFAULT 0 NOT NULL,
"AuthorID" INTEGER,
"DateCreated" TIMESTAMP DEFAULT Current_Timestamp,
"Complete" BOOLEAN DEFAULT false,
CONSTRAINT "PK_Forecasts" PRIMARY KEY ("ID"),
CONSTRAINT "PeriodTypeID" FOREIGN KEY ("PeriodTypeID") REFERENCES "Types" ("ID")
   ON UPDATE NO ACTION ON DELETE NO ACTION
)



Comments Comments
The issue was with the right-trim functionality in the ElevateDB engine when trimming off CRLF pairs.


Resolution Resolution
Fixed Problem on 3/20/2014 in version 2.16 build 2


Products Affected 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 PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image