Re: question on shared cursors with VB

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 6 Sep 2000 14:53:48 +0100
Message-ID: <8p5i9l$7kt$1@soap.pipex.net>

I'm fairly sure that the driver will do it for you if you use standard vb variables

eg
.....
state_str = 'CA'
query_str = "select city from p_city where state = " & State_str ...

etc
HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"d" <dreyz_at_hotmail.com> wrote in message news:OUx7UtqFAHA.322_at_cpmsnbbsa09...


> Hi Folks,

>

> The environement is VB 6.0, Orace 8.1.6

>

> Can someone tell me how to issue sql commands from a VB component using

 bind


> variables rather than weaving in the query parameter values in the command

> itself.

> e.g.

> variable state = 'CA'

> query_str = "select city from p_city where state = :state" and execute the

> query_str binding the variable state to the call

> instead of

> query_str = "select city from p_city where state = 'CA'  "

>

> Any help is appreciated.

> Thanks,

> Drey.

>

>

>

>

>

Received on Wed Sep 06 2000 - 08:53:48 CDT