(Sorry - this was posted under 'Chatter' by mistake!)
I have a local view that pulls in information from 2 tables - one a data table and the other a code-lookup table. The SQL looks something like this:
CREATE SQL VIEW MyView AS ;
SELECT MyDataTable.*, MyCodeTable.CodeDescription ;
FROM MyDataTable ;
LEFT OUTER JOIN MyCodeTable ;
ON MyCodeTable.CodeValue=MyDataTable.CodeValue
There is a KeyField set in MyDataTable and all the fields are marked as Updatable EXCEPT the CodeDescription field. When I delete a record in the view and issue a TableUpdate(), I get an error saying that 'No key columns specified for the update table "MyCodeTable". Use the KeyFieldList property of the cursor (Error 1492).' But I don't want to update MyCodeTable! What am I doing wrong?
Thanks,
Elyse Pomerantz