by ROY LUCMAN (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Tue 27th August 2002
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Delete a record using STORED PROCEDURE in SQLServer
' Stored Procedure Name : "StrdProcDelTmpAIMF"
' In VB6 Create a new project, in a form create command button name CmdDel
Private Sub CmdDel_Click()
On Error Resume Next
If MsgBox("You are about to DELETE 100001" + Chr(13) + _
"Any changes of this record will not be SAVE.", vbYesNo + vbDefaultButton2 + vbExclamation, "Message") = vbYes Then
DE.StrdProcDelTmpAIMF CLng("100001")
End if
End Sub