We have a remote view on an Oracle 8.0.5 table. If we bring the whole table and update a field with a browse, followed by a tableupdate(), it works.

If we specify a where clause to bring 1 record and update it, tableupdate returns .T. but the field is not updated. The field we try to update is Descr (updatable). We tried ODBC from MS and from Oracle.

Here's our code:

OPEN DATABASE bc
DELETE CONNECTION OracleConn
CREATE CONNECTION OracleConn DATASOURCE "liveedm" USERID "cmdSeries" PASSWORD "cmdseries"
CREATE SQL VIEW TestView REMOTE CONNECTION OracleConn SHARED AS SELECT * From IMST WHERE Item_Code = ?cItem_Code

DBSetProp('TestView', 'View', 'Tables','IMST')
DBSETPROP("TestView.Item_Code", "Field","KeyField",.T.)
DBSETPROP("TestView.Item_Code","Field","updatable", .T.)
DBSETPROP("TestView.Descr","Field","updatable", .T.)
DBSetProp('TestView', 'View', 'WhereType', 1)
DBSETPROP("TestView", "View", "SENDUPDATES",.T.)

What are we doing wrong?

TIA