Hi,

I am using Sybase 12.5, (Case-Insensitive!) and I have a very simple TQuery:
Select * from <InsertCoolTableNameHere> Where <ColumN> = 1

When I set the property RequestLive to True I get the error message "Could
not find object"
With a bit of experimenting I found out that the column name is case
sensitive?! Although
I have set sybase to be case-insensitive! If RequestLive is false then it
doesn't matter
what case <Column> is in, it works.

Any ideas?

Thanks in advance,
Andrew P. White

On Thu, 13 Mar 2003 14:08:40 +0100, "Andrew White"

I can't offer you much other than that the Oracle ODBC drivers (v8.0.4.4)
have a similar "bug".  If That driver is replaced with a newer driver,  or
the Microsoft ODBC for Oracle,  the problem goes away.  I actually spoke
with Oracle support for their problem and was instructed to include all
filed names included in double quotes and to use the exact same case as was
used when the field was created...

You might check with Sybase to see if they have any patches or updated ODBC
drivers to address this issue...

Jerry Bloomfield (TeamB)
--
http://www.teamb.com                                      JersW...@iwc.net
Please do *NOT* send private e-mail without prior permission (my anti-spam
filters will probably just delete it anyway <g>)