Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement