Difference between revisions of "TABLEREVERT()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 14: | Line 14: | ||
The TABLEREVERT() function is used to discard changes and restore OLDVAL() or currect disk data during buffered processing. | The TABLEREVERT() function is used to discard changes and restore OLDVAL() or currect disk data during buffered processing. | ||
| + | If the optional <workarea | alias> is specified, then the function will operate in the required location. | ||
==Example== | ==Example== | ||
Revision as of 12:38, 22 August 2011
Purpose
Function to discard changes and restore OLDVAL() or currect disk data during buffered processing
Syntax
TABLEREVERT(<expL> [, <workarea | alias>])
See Also
CURSORGETPROP(), CURSORSETPROP(), CURVAL(), GETFLDSTATE(), OLDVAL(), TABLEUPDATE(), SETFLDSTATE()
Description
The TABLEREVERT() function is used to discard changes and restore OLDVAL() or currect disk data during buffered processing.
If the optional <workarea | alias> is specified, then the function will operate in the required location.
Example
close databases clear set exclusive off open database southwind use customers // Set to known value before start replace customerid with "ALFKI" cursorsetprop("Buffering", 5, "customers") messagebox("Buffering set to " +etos(cursorgetprop("Buffering"))) ? "Original customerid value: " + customerid ? "Curval(): " + curval("customerid") ? "Oldval(): " + oldval("customerid") ? "Fieldstate at start: " + getfldstate("customerid") replace customerid WITH "RECIT" // Alter in another session ! recital -c "update southwind\!customers set customerid = 'MULTI' where recno() = 1" ? "Someone else just updated the record!" ? "New customerid value: " + customerid ? "Curval(): " + curval("customerid") ? "Oldval(): " + oldval("customerid") ? "Fieldstate after replace: " + getfldstate("customerid") tablerevert(.T.) ? "Reverted customerid value: " + customerid ? "Curval(): " + curval("customerid") ? "Oldval(): " + oldval("customerid") ? "Fieldstate after revert: " + getfldstate("customerid") replace customerid WITH "RECIT" ? "New customerid value: " + customerid tableupdate(.T.) ? "Updated customerid value: " + customerid ? "Curval(): " + curval("customerid") ? "Oldval(): " + oldval("customerid") ? "Fieldstate after replace and update: " + getfldstate("customerid") ?
Products
Recital, Recital Server
