Graham Leggett wrote: > ij> CREATE TABLE active ( active_id INTEGER NOT NULL, serial VARCHAR NOT > NULL, name VARCHAR NOT NULL, description VARCHAR NOT NULL, signature_id > INTEGER NOT NULL, PRIMARY KEY(active_id), UNIQUE (serial)); > ERROR 42X01: Syntax error: Encountered "NOT" at line 1, column 66.
I'm not exactly a Derby expert but in this case "serial" seems to be responsible. > ij> CREATE TABLE company ( company_id INTEGER NOT NULL, serial VARCHAR > NOT NULL, name VARCHAR NOT NULL, tradingas VARCHAR, registration_number > VARCHAR NOT NULL, vat_number VARCHAR, fsp_number VARCHAR, bank_account > VARCHAR, bank_sortcode VARCHAR, bank_name VARCHAR, bank_swift VARCHAR, > bank_reference VARCHAR, description VARCHAR, active_id INTEGER NOT NULL, > contact_id INTEGER NOT NULL, valid_from DATE, valid_to DATE, > signature_id INTEGER NOT NULL, PRIMARY KEY(company_id), UNIQUE (serial, > registration_number)); > ERROR 42X01: Syntax error: Encountered "NOT" at line 1, column 68. Same thing here. My guess: "serial" is a reserved word in Derby. Try to avoid reserved words as column names. Bye, Thomas. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
