Subject Re: [firebird-support] Table Problem
Author Martijn Tonies
Hi Luke,

> Sorry for the lame question... (newby)
>
> I have created a table using SQL. If I look at the database from say
> Borlands Database Explorer the table is there. But when I go to view
> the table or perform an operation such as SELECT or INSERT I get the
> error message the table does not exist.
>
> When executing the CREATE TABLE query I am following it with a commit.
>
> Any ideas?

Did you create it case sensitive? Like this:

CREATE TABLE "MyTable"

?

If so, you need to use the quotes always.

Alternatively, simply create it as:
CREATE TABLE MyTable
(without quotes)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com