Using bind variables from VB via ADO

From: Saul Behr <saulb.antispam_at_discoveryhealth.co.za>
Date: Tue, 27 Nov 2001 15:11:13 +0200
Message-ID: <3c0390fe$0$228@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 - 07:11:13 CST