Hello,

I'm new to interbase and I was having some troubles with the SQL syntax. How
come the SQL dialect used in the documentation to create a table does not
work with Interbase.

I am running Interbase 6.0 on Linux 6.2 and downloaded the corresponding
documentation.

The first table I create works fine ...
CREATE TABLE T1 (P1 INTEGER NOT NULL PRIMARY KEY);

... but the second table I create using the syntax from the documentation
doesn't! ...

SQL> CREATE TABLE T2 (F2 INTEGER FOREIGN KEY REFERENCES T1.P1
ON UPDATE CASCADE
ON DELETE SET NULL);
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 28
-FOREIGN
SQL>

...If I change the syntax to look like the following it works fine.
SQL> CREATE TABLE T2 (F2 INTEGER REFERENCES T1(P1)
ON UPDATE CASCADE
ON DELETE SET NULL);

Is there any settings with Interbase that will allow me to use the syntax
specified in the documentation?

Thanks

Cal Pittet