Hi,

With ElevateDB Manager, I am trying to create a table with a column
referencing a column in a different table, something like this:


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


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 ()

I have no idea what's wrong..?


TIA,
Lucian

Lucian,

I couldn't see nothing wrong - it apears to be a bug.


--
Fernando Dias
[Team Elevate]

Fernando Dias wrote:

> Lucian,
>
> I couldn't see nothing wrong - it apears to be a bug.

Thanks, I thought it was a documentation problem.

Lucian

Lucian,

<< 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 () >>

It's definitely a bug.  Sorry for the delay in getting back to you on this -
I actually looked at it and fixed it already, but forgot to respond to you.

The fix will be in 2.02 B11.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Lucian,
>
> << 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 () >>
>
> It's definitely a bug.  Sorry for the delay in getting back to you on
> this - I actually looked at it and fixed it already, but forgot to
> respond to you.
>
> The fix will be in 2.02 B11.

Thanks, glad it's fixed.
No problem with the delay no rush here, just started with EDB,
so... I'm catching up on things


Lucian