delete a record

[John Reynolds]

When I try to delete a record using the following code . . .


private Sub mnuPopDelete_Click()
DataEnvironment1.rscmdDepartments.Delete
End Sub




I get the following error . . .

"Row handle referred to a deleted row or a row marked for deletion."

Thanks for any solutions.
John

[Iouri]

Define the connection object and execute an SQL

sSQL = "delete from Table where UniqueKey = YourCriteria"

conn.Execute sSQL

Iouri Boutchkine
iouri@hotsheet.com

[John Reynolds]

Thanks for your help. But could you explain why
DataEnvironment1.rscmdDepartments.Delete
gives the error? Thanks