Deleting Records in a Data Environment

[casox]

What is the syntax for deleting a record using a data environment as opposed to using the ado control. ex. before when I was using an ado control on my form I just typed recordTB.delete. When I try dataenvironment.rsRecord.delete, I get the message 'it's not supported by the provider'. Can anyone help? Thanks,

casox

[Conniezc]

Try this one

1. Go to Data Environtment then goto the Properties (Right Click) on the Command you specified(i.e RECORD FOR dataenvironment.rsRecord.delete) then Goto Advance TAB. after that set LOCK TABLE to Optimistic coz READ ONLY will not allow delete, addnew, update OK....

Connie