I have a problem with VB Recordset.recordcount property
it always return (-1) here is my code:

Private Sub del_cmd_Click()
    If IDText.Text = "" Then
        MsgBox "Enter the ID number first ..."
    Else
        Sql = "select count(*) from Activ where ACTIV_ID = " & Text1.Text
        CN.Execute Sql
    End If
    MsgBox rs.RecordCount
    If rs.RecordCount = 0 Then
       MsgBox "The ID number is not found ..."
    Else
        n = MsgBox("Are you sure you want to delete record? ", vbOKCancel)
        If n = 1 Then
        Sql = "delete from Activ where ACTIV_ID = " & IDText.Text
            CN.Execute Sql
            MsgBox "Record deleted..."
       End If
    End If
End Sub

You never open the recordset object, you just use cn.execute, your recordset will always return -1 in this case.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

Hi there,

You may want to take a look here: http://www.adopenstatic.com/faq/recordcounterror.asp to understand why the recordset returns -1

BTW, is this really ASP? All those MsgBox statements make it look more like VB / VBA or a VBS script....

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.