>I am getting the following message on my view during requery:
>
I'm not sure this is it but the help for TABLEUPDATE() shows

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 occurs
 

it looks like the first parameter should be numeric 1 to force all rows to update.

Worth a try.
>

>Table buffer for alias "LV_VIEW_CONSUME_HISTORY" contains uncommited changes.
>

>
>the forms buffermode is 1: pessimistic
>bufferoverride mode is 1:
>
>I am updating a grid that is attached to "LV_VIEW_CONSUME_HISTORY" in the thisform.g2.column4.lostfocus
>
>

>TABLEUPDATE(.t.,.t.,'lv_view_consume_history')
>

>
>then on one of my buttons I am trying to requery that view again
>
>

>			lc_locid = .a
>			REQUERY('lv_view_consume_history')
>			.g2.refresh()
>

>
>why would I have commit issues after I have done tableupdate?
>
>Thanks
>Nick