Helen Borrie wrote:

>>> Another comment: that's not a valid table declaration anyway...you
>>> have to declare a FOREIGN KEY constraint explicitly and it's not a
>>> great idea to try and declare FK constraints in the same
>>> transaction as you define the table...it will likely cause your
>>> next exception, after you deal with the index overflow issue.
>> Ah, thanks for the heads up. I've never really used databases before and guides for getting started don't mention this kind of stuff, so I just worked off the IB 6 language reference for what was and wasn't possible.
>
> It's wrong according to the LangRef, though.

Actually according to the LangRef it is allowed (see the syntax on page
72, and the notes on page 77-78).

Mark
--
Mark Rotteveel