[dba-users] How to tell Base to NOT quote identifiers

[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. 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) Any help would be appreciated. Thanks Andrew 'Drew' Jensen