CODEWITHSUNDEEP
sqlfirebirdfirebird2.5
user2179817
user2179817

Reputation: 35

Error creating database table using FirebirdSQL

I'm trying to add tables to a FirebirdSQL database using FlameRobin but I'm getting the following error:

Error: *** IBPP::SQLException ***
Context: Statement::Prepare( CREATE TABLE drinks
(
    ...
) )
Message: isc_dsql_prepare failed

SQL Message : -104
can't format message 13:896 -- message file C:\Windows\firebird.msg not found

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, column 5
.

I've tried googling the problem but have been unable to find a solution. Does anyone know what the issue is here?

Upvotes: 2

Views: 2475

Answers (1)

Mark Rotteveel
Mark Rotteveel

Reputation: 109015

As it stands it looks like the CREATE TABLE in the question is the actual statement. In that case you are getting the error because it is simply invalid syntax:

CREATE TABLE drinks (
    ...
)

If I execute this in Flamerobin, I get almost the same error (except for me at line 2, column 5 (the first .), as the parser expects a column name there. At the ... you need to specify the actual columns (and optionally constraints) of the table.

For example:

CREATE TABLE drinks (
    ID INTEGER PRIMARY KEY,
    NAME VARCHAR(100) NOT NULL
)

Upvotes: 1

Related Questions