Problems with Recordset

[lenin]

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

[Ianpbaker]

Hi lenin

Try opening the recordset using the magic number, 3
This opens the recordset up so you can edit, delete.

myrecordset.open strsql,objcon,3

It also returns the record count. I cant remember which adOpen it relates to but it isn't one of the supplied by interdev.

Hope this helps

Ian