Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Does Oracle OLEDB Provider for Oracle support named variables?
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
![]() |
![]() |