🚀 go-pugleaf

I am using Delphi 3.01 C/S so I am not sure if it has been fixed in
future versions. I am not even sure if it's a bug or a feature but my
trace into the behaviour have all the tell tale signs of a bug.

Place a TQuery component on a form. The database property should point
to an Oracle alias. I am not sure how it will react to other SQL
servers (or more accurately, how other SQL servers will react to it).
Set the SQL property to a simple statment and qualify the table name
will the schema name as well. For example: select * from schema.table
Turn the Request Live property to TRUE and now try to set the Active
property of TQuery to True. You will get an error message from Oracle
that Table or View does not exist. Your first reaction may be that Live
Queries are not supported on remote SQL servers. Well, that may be true
but that is not what causing the error. You are getting the error from
Oracle and not Delphi....hmmm....
Time to dig in a little: Start SQL Monitor and then run the form
containing your TQuery. You will see that after a bunch of (seemingly
useless) conversation with Oracle, the Delphi sends (Select * from
"schema"."table") to the Oracle server---notice double quotes around
schema and table names. If you take the SQL statement as is, i.e. with
double quotes around the schema and table names and run it any SQL tool
(e.g. SQL WorkSheet from Oracle), you will get the same "Table or View
does not exist" error message. So, it is the quotes which are causing
this error.  FOLKS AT INPRISE SHOULD HAVE KNOWN BETTER.....!!!!

Regards,


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.