Check the return value of TableUpdate().
If it returns .F., try to get error info with aerror().
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)