Subject Re: IB_WISQL - quoted identifiers problem
Author Jason Wharton
Thanks for pointing this out. I have made the necessary adjustments in the
code for the Browse screen. I had made those once but somehow they got lost
in a merge or something. Or, I suppose I could have missed a few but I
really don't think so cause I know I had this working before.

But there was definitely a problem and I have now fixed it.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "John R Young" <john.r.young@...>
To: <jwharton@...>
Sent: Tuesday, November 07, 2000 5:50 PM
Subject: IB_WISQL - quoted identifiers problem

> Jason
> I have converted a database to IB6 dialect 3. As part of
> the coversion I changed all identifiers to mixed case, with
> spaces in some and not in others. All were in double quotes.
> Now IB_WISQL cannot access tables or fields which have no
> spaces but are in lower case. The error messages returned*
> say the identifier is unknown and put it in upper case
> throughout. Other tools have no problems. Is this a problem
> with IB_WISQL, or with the underlying IBObjects? Is there
> any work-around other than changeing all the identifiers
> again? (Sorry if I missed something in the documentation).
> John Young
> *example trying to browse table called "Antigens"...
> ISC ERROR CODE 335544569
> Dynamic SQL Error
> SQL error code = -204
> Table unknown
> TIB_Query: "frmBrowse.qrRelations"