Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OO4O Prepared Statements
"Kevin Crosbie" <caoimhinocrosbai_at_yahoo.com> wrote in message
news:b70929c28647d8e7e15ec3dcd80a1610_at_news.teranews.com...
> Hi,
>
> The documentation seems sketchy on this: How does one go about using
> prepared statments with OO4O in Visual Basic? Do I need to use Prepared
> Statments or are all statements that are created precompiled?
>
> The OraSQLStmt object seems to have a refresh method, so if I set my
> statement up as lets say an insert and then issue a refresh after changing
> my parameters, is that the equivalent?
>
> Thanks,
>
> Kevin
>
>
To use prepared statements you use bind variables. That is those Oracle
parameter things.
select ... from .... where col1=:bindVariable and ...
You can do it in an insert also. Just do 1, then reset the values of the
bind variables and do a refresh.
Jim
Received on Thu May 20 2004 - 14:06:06 CDT
![]() |
![]() |