There are more cursorsetprops necessary for updating a view. If you use the view designer to create a simple remote view, go to the Update Criteria tab and make sure all settings are correct, including the Send SQL updates check box. Now save the view.

Then generate the DBC code using GENDBC. You can now see all of the settings necessary for creating an updateable view.

>I am attempting to add a new record to a remote database via a remote view but am not succeeding. I can add the record to the view but it is not reflected in the remote (Oracle) database. When I edit existing records in the remote view those changes are being updated in the remote database.
>
>I need to be able to do this programmatically and not with the view designer or a wizard.
>
>My code for connection is as follows:
>
>CREATE DATABASE WHFDBC
>
>CREATE CONNECTION TestingConnection ;
> CONNSTRING 'DRIVER=ORACLE ODBC DRIVER;SERVER=DevTest;UID=ZIGGY;PWD=******;DBQ=devtest'
>
>CREATE SQL VIEW TestView REMOTE CONNECTION TestConnection SHARE AS ;
> SELECT * FROM ziggytest
>
>=CURSORSETPROP("SendUpdates",.T.,"TestView")
>
>One of the fields in the remote view is designated a primary key. In the view designer you "check" which field is primary as well as "Send SQLUpdates". From my understanding the cursorsetprop function and its parameters takes care of the "updating" but what takes care of the primary key designation when doing the process programmatically?
>
>Thanks,
>
>Wayne Frenck