>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 :-)

If you have to do this, you can COPY TO another file, and select from that.