Re: Mysterious query

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 28 Feb 2003 17:10:16 -0800
Message-ID: <3E600878.D7B5A659@exesolutions.com>

Peter Michelson wrote:

> Here's a poser: I have a Delphi 6 Enterprise app using the BDE to connect to
> Oracle 8.1.7.3. I've been getting sporadic "Ambiguous Column Name" errors
> from Oracle. When I ran SQL Trace it revealed an impossible query:
> somehow, a query which contains all fields from all of my database tables
> was being processed. This query even contains fields from tables in the
> database which aren't being used in the Delphi application. However, it
> does not seem to contain any key fields.
>
> Does anyone have any idea what might cause this behavior? Could this result
> from bad memory on the database server?
>
> Would appreciate any help,
> -P

This sounds like a Delhi/BDE issue rather than an Oracle issue. The behavior you describe is not a bug in Oracle and I highly doubt in the operating system unless your server is Win95 or similar which I would doubt.

In the future it would be helpful if you posted the SQL sent ... the SQL received at the database ... and the exact error message (full number and text).

Daniel Morgan Received on Fri Feb 28 2003 - 19:10:16 CST