Use Oracle's OLE Objects (OO4O). They have a nice interface, and support
bind variables which makes it very fast.
Jim
"Saul Behr" <saulb.antispam_at_discoveryhealth.co.za> wrote in message
news:3c0390fe$0$228_at_hades.is.co.za...
> Hi
> Does anyone know how to use Oracle bind variables from VB via ADO?
> I have a query:
>
> select MyField from MyTable where KeyField = <literal>
>
> ...which gets run quite frequently, with different values for the literal.
> I know it's more efficient to use a bind variable in place of the
literal -
> but how? What is the correct syntax?
>
> Please email me directly as well as replying to the group (Remove
> .antispam).
>
> Many thanks,
> Saul
> saulb.antispam_at_discoveryhealth.co.za
>
>
Received on Tue Nov 27 2001 - 11:41:01 CST
