>I am using a buffered table and then TableUpdate() to save it. What is weird is that from all appearances and stepping through the code, the NEW record seems to be saved. However, after closing the form and re-opening the form, the newly saved record is always gone. What have I missed? Oh, also, I am using a View to present the data from two tables and saving only the data from one table on the form. I also checked the box in the Local View that says "Send SQL Updates", and then put checkmarks on the fields I wanted to be updateable.
>
>I can see that any changes I make to any existing record do take; they are saved, but NEW appended records are not saved.
>
>Setup code in LOAD event:
>

>USE (.cTable) IN 0 EXCLUSIVE	&& Opens both ORDERS and Customers tables.
>SELECT (.cTable)	&& LV_ORDERS
>* Create indexes for Local View, LV_ORDERS.
>INDEX ON Lic_Plate TAG Lic_Plate
>INDEX ON ALLTRIM(LASTNAME)+ALLTRIM(FIRSTNAME) TAG LFNAME
>INDEX ON VIN TAG VIN
>INDEX ON ORDER_NO TAG ORDER_NO
>SET ORDER TO LFNAME
>
>* Set the buffering to Optimistic buffering.
>SET MULTILOCKS ON
>CURSORSETPROP("Buffering", 5, "lv_Orders")	&& Changes are only made to the ORDERS table.
>* Open other tables, which are used for DropDown Lists.
>USE States IN 0 SHARED
>USE Warranty IN 0 ORDER Warranty SHARED
>

>
>The precise code in my SaveIt() function is:
>

>LPARAMETERS tcTable
>LOCAL llGoodSave
>
>WITH ThisForm
>	llGoodSave = TABLEUPDATE(0,.T., tcTable)
>	IF !llGoodSave
>		WAIT WINDOW NOWAIT "Was not able to save changes."
>	ELSE
>		.newButton.Enabled = .T.	&& Turn New button back on now that data has been saved.
>		*.cmdLetter.Enabled = .T.	&& Turn Letter button back on,...
>		.printButton.Enabled = .T.	&& Turn Print button back on,...
>		.saveButton.Enabled = .F.		
>		.cancelButton.Enabled = .F.
>		WAIT WINDOW NOWAIT "Save was successful!"
>	ENDIF
>ENDWITH
>RETURN llGoodSave
>

This problem may happen if the table is buffered as well (the Orders table).