Sounds like the SQL commands used to delete the record are wrong
Check the Tables, UpdatableFieldList and KeyFieldList properties of the CA against the tables used in the CA.
Check the more obscure Delete* Properties
Check the BeforeDelete and AfterDelete events
Use the Before* Events to check what SQL string is send to the server,
>Hi,
>
>I am troubleshooting a problem. I am trying to delete a record from a table in the SQL Server. I am using cursor adapter.
>On the =tableupdate() command of the CA view, I get error:
>
>Invalid object name 'TableName2'
>
>
>TableName2 used to be in the database. But I removed it some time ago. Where could the connection between the table TableName1 and TableName2?
>
>TIA
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]