Hi Andrew, >> Now all my SQL turn into case-sensitive. I used a jdbc debugger to >> capture the SQLs send to Oracle. >> It is obvious that Base have quoted my sqls. >> SELECT * FROM registab WHERE KEY_NUM = '5700' >> goes to >> SELECT * FROM "REGISTAB" WHERE "KEY_NUM" = '5700' >> Now many of my sqls can't run any more. Crying or Very sad >> How could I tell Base to NOT to do this?
besides what Ocke already suggested: This also tastes a little bit like either a driver or an OOo problem. If OOo translates registab into "REGISTAB", then I would expect that the driver told OOo that it's okay to change the case. But obviously it isn't ... This means that either the driver is lying (by saying "it's okay"), or OOo is unrespectful to what the driver is saying. Would be interesting to have more information on used DB/driver/OOo versions. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
