Hi Andrew,

there exists at the moment no possibility to turn the quoting off. But I got another question, why doesn't he quote the strings by himself. The problem here seems to be that registab and REGISTAB are two different table names for the db. So quoting "registab" should help.

Best regards,

Ocke

Andrew Jensen wrote:
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)

Any help would be appreciated.

Thanks

Andrew 'Drew' Jensen




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to