Icon View Incident Report

Serious Serious
Reported By: Lucian Radulescu
Reported On: 3/29/2009
For: Version 2.02 Build 10
# 2969 Using REFERENCES Clause for Columns Causes Parsing Error in CREATE TABLE Statement

With ElevateDB Manager, I am trying to create a table with a column referencing a column in a different table, something like the following SQL.

I get this error: ElevateDB Error #700 An error was found in the statement at line 4 and column 28 (Expected PRIMARY, UNIQUE, FOREIGN, REFERENCES, CHECK but instead found ()

CREATE TABLE "B"
(
"RecRef"  INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0,
INCREMENT BY 1),
"ARef" INTEGER REFERENCES A(RecRef)
)



Comments Comments and Workarounds
The workaround is to use the full ADD CONSTRAINT syntax for the CREATE TABLE statement instead.


Resolution Resolution
Fixed Problem on 3/30/2009 in version 2.02 build 11


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

Image