Thanks Jim. That makes sense.
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:yk7rc.84585$536.14070246_at_attbi_s03...
>
> "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 Fri May 21 2004 - 02:28:47 CDT
