>Just a bit more information to my last cry for help. It seems that I am able to add new records to my oracle tables through remote views, but when I try to modify existing records it doesn't work.
>
>If I issue a tableupdate(.t.) in the command window while looking at the remote view in a brow window, the result is that the delete mark activates for every record that I modified. Then when I issue a requery(), the delete mark deactivates and all of my changes revert.
>
>I'm really confused because tableupdate is returning .T. and it is working fine for new records.
>
>What is so differrent about adding new records from modifying existing ones?

The following is from the VFP help on TableUpdate. If you are editing multiple rows before issuing the TableUpdate() command, then only the current record may be getting updated in Oracle.


TABLEUPDATE([nRows [, lForce]] [, cTableAlias | nWorkArea]
[, cErrorArray])

nRows Specifies which changes made to the table or cursor are committed.If nRows is 0 and row or table buffering is enabled, only changes made to the current record in the table or cursor are committed.

If nRows is 1 and table buffering is enabled, changes made to all records are committed to the table or cursor. If nRows is 1 and row buffering is enabled, only changes made to the current record in the table or cursor are committed.

If nRows is 2 and table buffering is enabled, changes made to all records are committed to the table or cursor. If nRows is 2 and row buffering is enabled, only changes made to the current record in the table or cursor are committed.

Unlike the 0 and 1 values for nRow, an error doesn’t occur when a change can not be committed, and Visual FoxPro continues to process any remaining records in the table or cursor. If cErrorArray is included, an array containing error information is created when an error occurs.

The default value for nRows is 0.