Jamie,

You can use any Xbase command on the uncommitted changes in the buffer. But you can't do SQLs unless you employ the "trick" Marcia and Hilmar show. And those might cause problems if there are triggers that might fail because you might not have all of the columns properly filled yet.

>If I have optimistic table buffering (buffermode = 5) on and have added records to a table they aren't included in the results of any select (sql select) on that table until I have performed a tableupdate().
>
>Is there a way to get them included in a select or do I just have to seek() records in this state ?