The point is that when I delete a record, I don't really delete a record. It simply sets a value in field REC_ID to 'D' and then saves the records.
And during this SAVE I get the error message pointing to a non-existing table. I did GoFish4 for this table name and nothing found.
It must be in one of the free DBF tables, used for meta configurations. So far, nothing comes up.
Thank you.
>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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham