Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi!
>
>If table is also in buffering mode, you require to issue tableupdate() for table only. When data are buffered for table, SELECT-SQL statement (it is ran by View2) cannot get these new data from memory buffers. SELECT in VFP works for phisical data only.
>
>It is recommended to keep tables with no buffering and use buffering only for views.
>
>>Two views with the same base table. All are optomistic row buffered. Value changes in View1 and TableUpdates are successfully done on View1 and the base table. When View2 is requeried the changed value does not exists. View2 must be updated also. Why? If the base table value has changed shouldn't a Requery of View2 include the changed value? Thanks!
>>
>>Regards, Renoir
Hi Vlad,
Ok, I removed the buffering on the table and only update the view and that worked; Requery works fine for all views. Thanks! One follow-up question - I thought that there were certain situations that required that the base table be buffered. Do you know any times when that is true?
Renoir
Précédent
Suivant
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