>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

It is probably a typo in your post, but CURSORSETPROP('Buffering',5,'MyTable') sets the optimistic table buffering, not pessimistic.

Could you post your exact SQL SELECT? How do you append these records?