TABLEUPDATE( [nRows [, lForce]] [, cTableAlias | nWorkArea] [, cErrorArray] ) nRows Description 0 If row or table buffering is enabled, commit only the changes made to the current row in the cursor. (Default) When working with CursorAdapter objects, Visual FoxPro executes the appropriate command in the InsertCmd, UpdateCmd, or DeleteCmd property for that row only. 1 If table buffering is enabled, commit changes made to all records to the table or cursor. If row buffering is enabled, commit only changes made to the current record in the table or cursor. When working with CursorAdapter objects, Visual FoxPro executes the appropriate commands in the InsertCmd, UpdateCmd, and DeleteCmd properties for each affected row. 2 Commit changes made to the table or cursor in the same manner as when nRows = 1. However, an error does not occur when a change cannot be committed. 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 occursit looks like the first parameter should be numeric 1 to force all rows to update.
>Table buffer for alias "LV_VIEW_CONSUME_HISTORY" contains uncommited changes. >>
>TABLEUPDATE(.t.,.t.,'lv_view_consume_history') >>
> lc_locid = .a > REQUERY('lv_view_consume_history') > .g2.refresh() >>