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]

Reply via email to