record number

[Lisgarero]

How can I get a record number from any table or query in SQL Server through ADO recordset, but CursorLocation in server side. There are some way to know it?

[SCIROCCO]

Do you mean record count (total number of records) or the position of current record of your server-side cursor? Here is the answer to both:

'Record Count
If rsSCIROCCO.Supports(adApproxPosition) Or rsSCIROCCO.Supports(adBookmark) Then
    RecordCount = rsSCIROCCO.RecordCount
End If

'Current Position
If rsSCIROCCO.Supports(adApproxPosition) Then
    AbsolutePosition = rsSCIROCCO.AbsolutePosition
End If

[Bombdrop]

If the recordset is forward only you can use the following to get a recordcount

Dim rs As New ADODB.Recordset
      Dim vCount() As Variant
      Dim lCount As Long
 
      rs.Open “SELECT * FROM Test”, “DSN=Test”, , ,           adCmdText
      vCount() = rs.GetRows()
      lCount = UBound(vCount, 2) + 1
      Debug.Print lCount

Hope this helps