Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Can't add primary key into tableb

Hello,

It seems that nothing works with FireBird database. I try to insert PRIMARY KEY according to examples I've fond on the web, but SQL fails. Here is my SQL request ALTER TABLE table1 ADD PRIMARY KEY (ID)

... and here is result:

Error1: Statut SQL: HY000 Code d'erreur: 1000 Erreur de syntaxe dans l'expression SQL

Error2: Statut SQL: HY000 Code d'erreur: 1000

Error3: Statut SQL: HY000 Code d'erreur: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

Any comments ?

Can't add primary key into tableb

Hello,

It seems that nothing works with FireBird database. I try to insert PRIMARY KEY according to examples I've fond on the web, but SQL fails. Here is my SQL request ALTER TABLE table1 ADD PRIMARY KEY (ID)

... and here is result:

Error1: Statut SQL: HY000 Code d'erreur: 1000 Erreur de syntaxe dans l'expression SQL

Error2: Statut SQL: HY000 Code d'erreur: 1000

Error3: Statut SQL: HY000 Code d'erreur: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

Any comments ?