Any programmers? I need help!

[BlackJetta]

Hi, everybody...
Straight ahead, I'm looking for someone who has had an experience with using bind variables with ADO and VB6. I'm trying to pass the list of parameters on the where - in () clause as a string into a bind variable, such as this:

...

Set objCn = New ADODB.Command
Set objRs = New ADODB.Recordset

objCm.Parameters.Append _
objCm.CreateParameter( "prVar3", adVarChar, adParamInput, 100, "'blah1', 'blah2', 'blah3'" )

strSql = " SELECT * FROM table "
strSql = strSql & " WHERE param in ( : prVar3)"

...

objCm.CommandType = adCmdText
objCm.CommandText = strSql
Set objRs = objCm.Execute

After the execution of the command, the recordset objRs is not returned any records.

However, if I run the SQL query directly in TOAD like htis:

SELECT * FROM table
WHERE param in ('blah1', 'blah2', 'blah3')

I have so many records returned.

NOTE: I did test the code with the other cases, such as using this

objCm.Parameters.Append _
objCm.CreateParameter( "prVar3", adVarChar, adParamInput, 100, "blah1" )

and had the records returned into the recordset.

Any ideas? May be someone had to deal with something like that?
Oracle FAQ seems to be helpless (it also states that I cannot use explicitly declared bind variables with ADO, but question marks (?) only, which, as it turned out, I can...)

Thanks in advance!!!

[old-reb]

Hello BlackJetta,

I don't have a clue but here are some folks that may be able to help you or at least send you to a place for help.

http://www.duxcw.com/yabbse/index.php#2

old reb

[BlackJetta]

Originally posted by old-reb
Hello BlackJetta,

I don't have a clue but here are some folks that may be able to help you or at least send you to a place for help.

http://www.duxcw.com/yabbse/index.php#2

old reb

Thanks, Old-Reb!
Hopefully, they'll answer it there
I made these "bind variables" working in general, but this particular task.