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: Does Oracle OLEDB Provider for Oracle support named variables?

Re: Does Oracle OLEDB Provider for Oracle support named variables?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 07 Apr 2006 18:53:52 +0200
Message-ID: <e165f0$olj$1@nntp.fujitsu-siemens.com>


Tzanko schrieb:
> Thanks Volker,
>
> If I constructed my SQL string as you suggest: insert into mytable
> (mycolumn) values (:mybindvariable), do you know in ADO how to pass the
> parameters, so that they are bind correctly. Do you just give it the
> same name (:mybindvariable) when constructing the parameter object?
> Something like:
>
> pCommand->Parameters->Append(
> pCommand->CreateParameter(_bstr_t(":mybindvariable"),
> adInteger, adParamInput, 4, _variant_t(lMyBindVariableValue)));
The parameters colection has and add method. I use that. Also, the ":" is not part of the name.

Lots of Greetings!
Volker Received on Fri Apr 07 2006 - 11:53:52 CDT

Original text of this message

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