Am Freitag, den 30.12.2005, 01:55 -0500 schrieb Andrew Jensen: > Hi, > > A user on the OOOForum board posted this recently: > > > 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? > > I am simply passing it along hoping to get some information for him. I > will pass back anything from here to him at the forum. > (Yes, I told him he could simply do this himself, but he asked if I > would do this)
I'm not sure if quoting will go away completely, but in forms or queries he can try switching to "native sql" or "passthrough" or whatever it is named. When programming there is the property "css.sdbc.RowSet.EscapeProcessing" that should do the same thing. HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
