Re: OO4O Prepared Statements

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 20 May 2004 19:06:06 GMT
Message-ID: <yk7rc.84585$536.14070246@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 Thu May 20 2004 - 14:06:06 CDT