Results 1 to 9 of 9

Thread: [RESOLVED] why recordcount returns -1?

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2007
    Posts
    48

    Resolved [RESOLVED] why recordcount returns -1?

    Why I get recordcount=-1 in the following program?
    Code:
    Call connectionOpen
        Dim rs As ADODB.Recordset
        Set rs = New ADODB.Recordset
        Dim strSQL As String
        strSQL = "SELECT * FROM daily_list_cell WHERE show='Yes'"
        rs.Open strSQL,connection
        MsgBox rs.RecordCount
        rs.Close
        Set rs = Nothing
        Call connectionClose
    Last edited by abdbuet; Aug 27th, 2007 at 02:26 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width