Thanks for the reply Vlad. I have tried to change the Sql Where option form Key and Modified to Key and updatebale. I have also changed the SQL update between Update and Delete and Insert.
I have also use Eric Moore's eview to generate code, delte teh view and run the generated code.
The Pardox Table I am trying to modify is a Paradox 4.x table (DOS). The real frustration is that this thing worked for close to a year and now nothing.
>Hi!
>
>Strange. Try to change the SQL Where option in the view designer.
>
>>I am attempting to update a Paradox Table using a Remote View. I am reading data from the Paradox Table OK. When a field is changed, I get a Connectivity error stating that an updateable query must be used. My Update criteria has all fields listed in the view as updatable including the PK which is also specified(by checking in the View Designer). I have Send Sql Updates selected.
>>
>>What am I missing?
Ken Wardwell