Re: Cannot get parameterized queries to work for ORACLE

Just a wild stab in the dark.

But could it be that ID is a reserved word?

Have you tried the same code on LocalSQL?

HNY Railton....

Andrej Gabara wrote:
>
> Hi,
>
> I'm using Delphi 2 C/S and Oracle 7.3. I'm trying to do the following:
>
> Query.SQL.Add('SELECT * FROM Foo');
> Query.SQL.Add(' WHERE FooId = :ID');
> Query.Prepare;
>
> Query.ParamByName('ID').AsString := 'Duh';
> Query.Open;
>
> Using the Oracle SQL Links driver, I get an EDBEngineError exception
> for the 'Query.Open' instruction. The message is something like
> 'Capability not supported' (I'm using the German version, and the German
> message is 'Operation nicht anwendbar'). Then I tried the same source on
> an Interbase database using the Interbase SQL Links driver, and all is
> well.
>
> Why does the Oracle SQL Links driver not support such a very basic
> capability? Is this a bug?
>
> I appreciate any feedback,
>
> -Andrej
>
> PS: I'm using Oracle SQL Links driver version 3.0
Received on Sat Jan 03 1998 - 00:00:00 CST