Re: Cannot get parameterized queries to work for ORACLE

Hi Railton,

I haven't tested it on LocalSQL because it works on Interbase. I'm not using LocalSQL because it is a bit different to real SQL.

Thank's
Andrej

Railton Frith wrote:
>
> 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 Mon Jan 05 1998 - 00:00:00 CST