>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 ?
>
>Cheers
>Jamie
You can navigate the original table (SELECT - SQL does the equivalent of USE ... AGAIN), or issue TableUpdate(). If you don't want to save changes yet, you can BEGIN TRANSACTION, then TableUpdate(), then do your SELECT, then ROLLBACK.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)