Hi,
I had a problem last week with a component returning a recordset to a Vis InterDev page, and not having all the recordset properties exposed. I emailed and got a response pointing to the cursortype of the returned recordset ( thanks clunietp ). However when I change the cursortype in the component ( to adopendynamic or anything else ) it fails to return the correct recordcount ( returns -1 pointing STILL to cursortype). When I check the cursot type it is set to 0, which is correct.

Is the code below the most effective method of setting the cursor type? I cannot use the recordset.open syntax as this is a parameterized command query.

Can somebody point me in the right direction?

Set lrs_getOpenCalls = New ADODB.Recordset
lrs_getOpenCalls.CursorType = adOpenDynamic
Set lrs_getOpenCalls = comm_getOpenCalls.Execute
MsgBox lrs_getOpenCalls.RecordCount
Set get_Open_Calls = lrs_getOpenCalls


Thanks in advance