> It's a very simple table:
>
>
> /* Table: user_info, Owner: SYSDBA */
>
> CREATE TABLE "user_info"
> (
> "userid" INTEGER NOT NULL,
> CONSTRAINT "PK_user_info" PRIMARY KEY ("userid")
> );
>
> It does exist, atleast in the IBOConsole. =)

No it doesn't, the table that DOES exist, however, is
"user_info", not USER_INFO.

If you create your objects with quotes ( "user_info" ) they become
case sensitive. This is why Firebird Workbench, the tool I have created,
turns everything to Uppercase by default ( see www.upscene.com ) to
avoid any case sensitivity problems.

btw - your column "userid" is case sensitive as well. The nasty thing
with case-sensitive objects in Firebird, is that you need to use the
quotes everywhere:

SELECT "userid" FROM "user_info" WHERE ... etc...


See - ask your questions in a way we have the info, get an answer in
return that is useful :)

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> >
> > Hi,
> >
> > > I've created a table named user_info, in a database called
> > test, from
> > > IBOConsole. Dbowner is SYSDBA.
> > > When I try to insert data from IBOConsole using a SQL
> > statement I get
> > > this error:
> > >
> > > ISC ERROR CODE:335544569
> > >
> > > ISC ERROR MESSAGE:
> > > Dynamic SQL Error
> > > SQL error code = -204
> > > Table unknown
> > > USER_INFO
> > > At line 1, column 13.
> > >
> > > Why?
> >
> > Well - do you want the most obvious answer?
> >
> > Your table USER_INFO doesn't exist!
> >
> > If you want a more helpful answer, give us some more information, try
> > some DDL (metadata statements) at least...