[RESOLVED] counting records

[macmatira]

.pls help me..

using adodc
how to count the records entered in the table.

i've tried this code

Dim rec As ADODB.Recordset
Text1.Text = rec.RecordCount

but it always returns -1

??? why..

[RhinoBull]

There are couple of reasons:

1. You need to set recordset CursorLocation to client first.

Dim RST As ADODB.Recordset

    Set RST = New ADODB.Recordset
    rst.CursorLocation = adUseClient

2. Not every data provider supports the record count.

[macmatira]

ty i will try.

[macmatira]

thanks....

i got it...

pls help me, if i will encounter another problem in my way..

thank you very much!

[macmatira]

before the prob.
i would like to thanks for your kindness.
thanks for the answers.

pls help me for this another prob.

here is the link

http://www.vbforums.com/showthread.php?t=650166

[macmatira]

There are couple of reasons:

1. You need to set recordset CursorLocation to client first.

Dim RST As ADODB.Recordset

    Set RST = New ADODB.Recordset
    rst.CursorLocation = adUseClient

2. Not every data provider supports the record count.

i got a trouble.

pls help me again.

here is the code i've entered.

Private Sub Command1_Click()
Set rec = New ADODB.Recordset
rec.CursorLocation = adUseClient

'to see how many records in the table
Text1.Text = rec.CursorLocation

MSFlexGrid1.TextMatrix(1, 0) = rec.Fields(0)

End Sub

then the attachment is the screen shot of the error.
the error is in the rec.fields (0) and said that:
Item cannot be found in the collection corresponding to the requested name or ordinal.

[GaryMazzone]

That is because there is no column name CursorLocation in the record set. That is an attribute of a recordset. What you want is rec.RecordCount

[macmatira]

my first problem is how to count the records.. but it is resolved using the codes given by RhinoBull...

then now, i have the problem of viewing the record using the msflexgrid
...

if i'm not mistaken, the code.

Set rec = New ADODB.Recordset
rec.CursorLocation = adUseClient

is use to move the cursor to the last row of the table.

using other command button. (command2)
i can view it, and there is no error.

but i want is to know how many records and the same time viewing the record in the msflexgrid.

[Hack]

When you use a client side cursor, the recordcount property will return an accurate number.

-1 is returned for a recordcount only when you are using a server side cursor.

[macmatira]

thanks sir, i got it. (about the client and server side cursor)

but my problem now,,,

the second problem i've mentioned above. (with attachment)

[RhinoBull]

the error is in the rec.fields (0) and said that:
Item cannot be found in the collection corresponding to the requested name or ordinal.

You are not selecting any records - if you do then at least it's not presented here.
There must some kind of "Select * From..." sql staement executed.
If you are beginner to database programming I would recommend checking out Database FAQ section for lots tutorials, tips and sample code.