General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Adding New Record using Remote 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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only