General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Is there a way to select (SQL) the new value of a field from a buffered table? The buffereing is optimistic table buffering. If you do a LOCATE on the table, it uses the newly changed value. But if you do a SELECT from that table, it uses the old state of the table (i.e., no newly changed data or inserted rows). I want to do duplicate checking before I update the table.
>
>TIA,
>
>-jam :-)
Look at the OLDVAL() and CURVAL() functions.
BOb
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only