Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cannot get parameterized queries to work for ORACLE

Re: Cannot get parameterized queries to work for ORACLE

From: Andrej Gabara <anga0004_at_stud.uni-sb.de>
Date: 1998/01/05
Message-ID: <34B0FDE4.58A29F6A@stud.uni-sb.de>#1/1

kroma wrote:
>
> > Query.ParamByName('ID').AsString := 'Duh';
>
> Because your doing it wrong. The string must be in quotes. Try
> Query.ParamByName('ID').AsString := '''Duh''';
>
> Thats three single quotes on each side.

I don't think that I'm doing it wrong. It should be

        Query.ParamByName('ID').AsString := 'Duh';

'''Duh''' doesn't make sense. Besides, I've tested the app with Interbase and it works fine. Only ORACLE gives me headaches. Received on Mon Jan 05 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US