Graham Leggett wrote:
ij> CREATE TABLE property ( property_id INTEGER NOT NULL, key VARCHAR
NOT NULL, value VARCHAR, PRIMARY KEY(property_id));
ERROR 42X01: Syntax error: Encountered "key" at line 1, column 55.
What this tells you is that a column name "key" is not valid in Derby.
You should choose another name. Although you might succeed creating a
valid SQL file by patching some templates, Village will barf at you when
you want to insert something.
Is derby still supported by torque v3.3?
It sure is.
Bye, Thomas.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]