As Hilmar said
You need to trap the result of tableupdate, e.g.
if not tableupdate(...)
=aerror(laError)
=messagebox(laError[2])
endif
>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.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst