Hi Mario,

a view is always buffered. If row buffered (the default) the commit would occur when (if) you move the record pointer, or when you issued a tableupdate() command.

Hank

>Hi, I have a remote view on an Oracle table. When I issue INSERT statements on the view I sometimes find that the view has not been updated, not only in the Oracle database but also when I browse the view from VFP itself. After a couple of statements more, some of the data has been "commited" to the view.
>
>Is there a way to tell the view to update itself, either in VFP, Oracle or at both places at the same time ?
>
>Thank you in advance for your awnsers.