>Can you please give a brief example of buffering, say when I've selected a record and presented to the user on a form for editing, what's the syntax for commiting the edit/update to the table, or reverting to the original data?

PMFJI, Here is an example :). For a detailed explanation see: "Data Buffering in Visual FoxPro" in the articles archive here in the UT.

Use myTable
CursorSetProp("Buffering" , 5, "myTable") && Turn optomistic table buffering on

Replace myfield With "Thud" In myTable && change some data
** The field could also be bound to a control on a form.

Do Case
	Case Dow(Date()) = "Monday" && make the user a little more miserable
		Tablerevert(.T., "myTable") && discard any changes to the table

	Case Dow(Date()) = "Friday" && Make the user happy
		Tableupdate(.T., .T., "myTable") && save changes to the table.

	Otherwise && be ambivalent
		Messagebox("Today just isn't your day!")

Endcase