General information
Title:
TableUpdate not pushing changes to base tables
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.
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