you are missing not null of the primary key field
Slim

-----Original Message-----
From: catalinplacinta [mailto:catalin.placinta@...]
Sent: 18/09/2003 16:18
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Create table script


I am creating a table in Firebird with the following script:
SQL> CREATE TABLE nomconsumabile (idnomenclator INTEGER (10),
denumire VARCHAR (50), datainreg TIMESTAMP, idfurnizor INTEGER (10),
PRIMARY KEY (idnomenclator));
when i run the sql query, i get the following error:

Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 52
-(

I have searched for an explanation, but none found up to now.
Any ideas? Thanks in advance



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




INTACT Software
2 Mourne View
Dublin Road
Dundalk
Co. Louth
Ireland

W: www.intact.ie
T: +353-42-9331742
F: +353-42-9326357

Confidentiality Note: The information contained in this email and
document(s) attached are for the exclusive use of the addressee
and may contain confidential, privileged and non-disclosable information.
If the recipient of this email is not the addressee, such recipient
is strictly prohibited from reading, photocopying, distribution or
otherwise using this email or its contents in any way.