>As I understand if I work in buffering mode,
>information is only recorded on table when
>run
>
>tableupdate ( )
>
> Can anybody tell whether it's correct ?
>
>What's the diference between optimist and pessimist ?
>I read help but dind't understand
>
>When do I have to use command: tablerevert ( ) ?
>
>
>Thanks
>Moisés


hi Moisés,

For buffering you have to use BufferModeOverride property of cursor. You want to know that how one can use pessimistic buffering and optimistic buffering, isn’t?

1) For pessimistic buffering you have to set BufferModeOverride = 2 (Row Buffering) in cursor object of data environment. Now if you use this type of buffering then no one else can modify that particular record in which you are editing. In other word it LOCKS record while you are modifying. It only release when record pointer moves. IF you issue Tableupdate() then it will save record . To undo changes you can issue Tablerevert() so it will come to original position .

2) For optimistic buffering you have to set BufferModeOverride = 3 (Row Buffering) in cursor object of data environment. Now this if you use this type of buffering then any person can modify that particular record in which you are editing. In other word it does not LOCKS record while you are modifying, but it’s LOCK when you issue Tableupdate() to save record . To undo changes you can issue Tablerevert() so it will come to original position .

3) You can use BufferModeOverride as 4 and 5 too for table buffering. But if you use VIEWS as cursor then you have to use 3 and 5 .

4) IF you change some thing in record , after that you want it to be in original postion then you have to issue Tablerevert()

Hope above description will help you.

Bye
Mihir