>Hi All,
>
>I am writing an application in which the tables are set up to pessimistic buffering, i.e = CURSORSETPROP('Buffering',5,'MyTable').
>For some reason, when I run a SELECT SQL after that the appended records are not included in the search results.
>Any explanation? Maybe any way to get around this?
>
>Thanks
>
>Jonathan Feldman
Reason: SELECT - SQL re-opens the table, and the appended records don't yet exist on disk, until you issue TableUpdate().
Workarounds:
1) Save your changes with TableUpdate() first.
2) Select the same workarea where you are doing changes, and COPY TO a temp table.
HTH, 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)