-
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
-
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
