Persistent Recordset Problems

[lenin]

Hi,
I sent in an issue a couple of days ago regarding the fact that WHATEVER cursor type I used in a parameterised command query, I kept getting a record count = -1. I know this is indicative of an incorrect cursor type. I have tried ALL the possible cursort types and still get the same result for record count.

As a side issue, I tried the same this i.e. returning records from SQL Server using a DE, and the recordcount works fine. This setup is exactly the same as my parameterised queries apart from using a DE, i.e. both implement classes to return an ADODB.Recordset.

This is very frustrating. Has anyone came across this before or is able to take a bit of time to try to recreate? I will be more than happy to provide source.

Previous email below

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.

Lenin

[Jimbob]

i **Think** it also has to do with the type of locking you use, eg: -

optimistic locking seems to give a recordcount with dynamic and static cursors, but not with forward only...

[lenin]

JimBob,
tried all locking types, same result. Thanks for the input though.

Lenin

[Clunietp]

your database is SQL server? what version?

try these properties, I KNOW these work for me (SQL 7)

cursorlocation = Client
cursortype = static


these ALWAYS work when retrieving the recordcount from SQL Server (and MS Access too)....

if not, lets see your code...