Re: Using bind variables with VB and ADO but viewing SQL_AREA shows non-bound parameters

You could switch to OO4O. (Oracle's Ole Objects.) Has nice syntax, uses bind variables, is fast.
Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"gary gibbons" <aalegrias_at_yahoo.com> wrote in message
news:900c6d6a.0305071422.255f07d5_at_posting.google.com...


> I am using VB components to access ORACLE 8.7

>

> I am using the parameter syntax for paramter passing with ADO:

>

>    Set mySelectCmd = New ADODB.command

>

>     mySelectCmd.activeConnection = myConn

>     mySelectCmd.CommandType = adCmdText

>     mySelectCmd.CommandText = "select username from member where

> memberid = ?"

>     mySelectCmd.Parameters.Append

> mySelectCmd.CreateParameter("userId", adInteger, adParamInput, ,

> userId)

>     Set myRSReturn = mySelectCmd.Execute

>

> The Select works, but viewing the SQL_AREA table on the oracle DB,

> I see no indication of bind variables being used. Rather than seeing

> the ":varname" format, I see a SQL entry for each unique value,

> and this is not Oracle binding behavior.

>

> It seems to me that ADO is not really binding the values at all.

>

> ANy ideas how to solve this?

>

>

> gary gibbons

> aalegrias_at_yahoo.com