Re: Update database record
After you have created connection object to the database you can execute an SQl there.
sSQL = "delete * from Table"
cn.Execut sSQL
Iouri Boutchkine
[email protected]
Re: Update database record
Hello:
You can use ADO to do it:
Private Sub Command1_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub Command2_Click()
Adodc1.Recordset.Delete
End Sub
Private Sub Command3_Click()
Adodc1.Recordset.Update
End Sub
Private Sub Command4_Click()
Adodc1.Refresh
End Sub
Private Sub Command5_Click()
Adodc1.Recordset.Find "DIVISION = 'eleven'"
End Sub
After you have click on a delete, addnew, and update, you got to click refresh button.
Good Luck.
I hope this helps.