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