On Feb 7, 2008 1:39 PM, Roman Rokytskyy <rrokytskyy@...> wrote:

> That complete fix is a bit more complicated, but I think that this code
> can fit your needs. The issue is that it is quite possible that people
> will use lower-case notation for unqouted table names, in this case your
> fix won't work. Just as a warning.

I always create my tables in lowercase. The only time I am actually
using mixed case quoted is when I use a tool called xplain2sql, which
generates quoted identifiers.

I have run the following tests:

create table mytable (id integer not null primary key, val varchar(30));
CREATE TABLE MYNEWTABLE (ID INTEGER NOT NULL PRIMARY KEY, VAL VARCHAR(30));
create table "MyNewTable" ("Id" integer not null primary key, "value"
varchar (30));
create "mytable" ("id" integer not null primary key, "val" varchar(30));

I have created them using the API, not isql. And they all work. I am
able to extract the metadata from them, as well as data.

But, since you have implemented the code, you know better than me. I
will wait for the update. Just like you said, it is working for me.

Thanks in advance,

Fidel.