[RESOLVED] rst.recordcount

[nagasrikanth]

Hi ..

Iam really wondering that y iam not getting the record count that which was buit by using ADOs ..
Im sure that there are records in the recordaset object..Im able to loop through all the records..but y was the "recordcount" function returing value as -1????

Can any one tell me that is there any thing specifically i have to do to get record count ...

thanx & regards
Anu..

[Mark Gambo]

Can you post your code? Also take a look at the links in my signature regarding connecting via ADO to either an Access DB or MySQL.

[Hack]

Use either adOpenKeyset or adOpenStatic as the CursorType for server side cursors or use a client side cursor. Client side cursors use only adOpenStatic for CursorTypes regardless of which CursorType you select.

[shirishdawane]

Hello Hack,

the same problm i am getting & i also posted thread regarding my problem today mornig only subjected that "working fine with SQL server 2000 but not in VB 6.0", but not get any satisfactory answer.....plz help...it will be benificial for me as well as this person....

[nagasrikanth]

yes....it worked out....thanQ hack..

but why the problem occurs with adopendynamic????

any how thaks once again for u r help..

[Hack]

Then, change your cursor type and you will get a proper recordcount.

If you don't wish to change your cursor type, then the alternative is to do a SQL SELECT COUNT

[lerroux]

hi, i'm having a similar problem... i tried to change my cursor type to either openkeyset or openstatic and still generated a problem...
for openstatic, i develop an error: "arguments are of the wrong type..."

for openkeyset, i still get a -1 value for recordcount....

how do you do a SQL SelectCount?

[Mark Gambo]

Hack was talking about using the following sql statement:

strSQL = SELECT Count(*) as Counter  FROM YourTableName WHERE Yourcondtion