>Hi All,
>
>Does anybody have an idea how to fix the error "No update tables are specified. Use the Tables property of the cursor (Error 1491)".
>
>I am using remote view as data source.
>The remote view has a buffering of Optimistic table buffering.
>But when I issue the tableupdate() the error appears.
>
>any help would be appreciated.

Open the view in the View Designer and select the Update Criteria lab. Make sure the necessary fields are checked, and that the Send SQL Updates checkbox is checked.


Hi Chris,

Thank you for your response. But the fields and Send SQL Updates checkbox are already checked when I encounter the error. I have several remote view in the database and some of the views works properly except the one that have an error. I have tried to recreate the view but still the error occurs.

Any known issue about this problem?