Subject | Re: [firebird-support] Table Problem |
---|---|
Author | Martijn Tonies |
Post date | 2004-01-29T15:06:35Z |
Hi Luke,
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
> Sorry for the lame question... (newby)Did you create it case sensitive? Like this:
>
> 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?
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