Buffering in view

[Toms Ng]

hi,
i want to know that if i create a view(local or remote)
what is the value of buffermode.
i find that the view buffermode is 3 , is this a default setting.
also , when i insert , update , or delete in the view , the table is trigger
at that same time .i need not to execute the tableupdate() function.
is it right.
can you tell me the different between row buffering (3) and table buffering(5).

Toms

[Barbara Peisch]

Row buffering (buffering = 3) is the default for views. You can change it
to table buffering with CURSORSETPROP('Buffering',5). If your view is using
row buffering, then moving the record pointer, along with a lot of other
commands will trigger a tableupdate. (It's called "row buffering" because
it won't store changes for more than one row at a time, and when you do
anything to change the current row, it saves the changes.)

If you change to table buffering, than you can issue tableupdate() when you
want to update all the rows with changes. You should read the help file
about the parameters that tableupdate accepts, because you need to specify
if you only want the current row updated or all rows with changes, and
whether or not to force updates if the data has changed in the interim.

--


-BP
www.peisch.com

"Toms Ng" <tomsng@sinaman.com> wrote in message
news:3baaa3e9$1@news.devx.com...
>
> hi,
> i want to know that if i create a view(local or remote)
> what is the value of buffermode.
> i find that the view buffermode is 3 , is this a default setting.
> also , when i insert , update , or delete in the view , the table is
trigger
> at that same time .i need not to execute the tableupdate() function.
> is it right.
> can you tell me the different between row buffering (3) and table
buffering(5).
>
> Toms
>