Re: query on recordset in visual basic


"ekkehard.horner" <ekkehard.horner@xxxxxxxx> wrote in message
news:478e0abe$0$25384$9b4e6d93@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Someone is asking me to do a "query on a recordset" in VBScript,
claiming that in Visual Basic this

set conn=ADODB.connection
set rs1=ADODB.recordset
set rs2=ADODB.recordset
conn=<<set to someDB>>
rs1.open "select ename,age from emp"

rs2.open "select ename from rs1 where age >10"

msgbox rs2.recordcount

works. I doubt that - how could someDB know/access rs1 -
but not being familiar with Visual Basic, I thought it
wise to ask the experts.

If it is possible in Visual Basic, I would be very grateful
for a pointer to pertaining docs/samples.

Anybody who can do this in any other language could make my
day by telling me about ist.

Thanks.

They left a bit out.
http://msdn2.microsoft.com/en-us/library/ms676589(VS.85).aspx

Note: "VBScript" while related, is NOT VB nor VBA. In the future you should
post in "microsoft.public.scripting.vbscript" for the best answers.

hth
-ralph


.