I have a CursorAdapter that pulls in a multi-table view from Sql Server. I update a column in the view and issue a TableUpdate() but no changes make it back to the base tables. This stuff worked on a Fox view but not against Sql tables.

Here are my prop settings:

loAdapter.SelectCmd = lcSelect && select string that does pull back data

loAdapter.AllowInsert = .t.
loAdapter.AllowUpdate = .t.
loAdapter.AllowDelete = .t.
loAdapter.BufferModeOverride = 5 && buffering
loAdapter.FetchMemo = .t.
loAdapter.FetchAsNeeded = .t.
loAdapter.FetchSize = 200
loAdapter.SendUpdates = .t.


The KeyFields, UpdateNameList and UpdateFieldList are all populated and the later two contain the column I am trying to update.

* I replace a value in the view and the tableupdate
TABLEUPDATE( 1, .t., loAdapter.Alias )


I have tried both setting the UpdateCmd prop and allowing the adapter to build it internal. I even set a manual update statement and pass it in via Sqlexec() and that does not update. My connection is open and valid.

Any ideas?
Thanks.