Re: Mysterious query

>>>>> "Peter" == Peter Michelson <pete77r_at_hotmail.com> writes:

 Peter> Here's a poser: I have a Delphi 6 Enterprise app using the BDE
 Peter> to connect to Oracle 8.1.7.3.  I've been getting sporadic
 Peter> "Ambiguous Column Name" errors from Oracle.  When I ran SQL
 Peter> Trace it revealed an impossible query: somehow, a query which
 Peter> contains all fields from all of my database tables was being
 Peter> processed.  This query even contains fields from tables in the
 Peter> database which aren't being used in the Delphi application.
 Peter> However, it does not seem to contain any key fields.

 Peter> Does anyone have any idea what might cause this behavior?  Peter> Could this result from bad memory on the database server?

I doubt the cause would be bad memory on the server - I mean, what would be the odds of bad memory resulting in SQL which was still legally formed?

Can you get a dump of exactly what SQL is being passed via the BDE link? I would look at the client end and the connection software before considering Oracle - if there was a bug in Oracle which caused it to somehow change your sql I'd imagine others woul dhave noticed it by now.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!