Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    4

    Unanswered: how to delete?..

    what codes should i use if i want to delete a record in sql using vb6?.,

    because this doesnt work..

    Confirm = MsgBox ("Are you sure you want to delete this record?", vbYesNo, "Deletion Confirmation")
    If Confirm = vbYes Then
    adodc1.Recordset.Delete
    MsgBox "Record Deleted!", , "Message"
    Else
    MsgBox "Record Not Deleted!", , "Message"
    End If

    -grrr.,they are teaching us about sql now??.,
    gggrrrrrr!!!!.,our skuL is useless!.,

  2. #2
    Join Date
    May 2007
    Posts
    49
    connectionObj.execute ("Delete from tablename where keyColumn=" & keyVal)
    Mihir Mehendale
    DB Team @ Clarion
    Clarion Technologies
    (SEI CMMI Level 3)
    Pune, India
    www.clariontechnologies.co.in
    www.vEmployee.com

  3. #3
    Join Date
    May 2007
    Posts
    4
    thankyou.,

Posting Permissions

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