Information générale
Catégorie:
Codage, syntaxe et commandes
>>3: I found that unless I set SEND SQL UPDATES on in the View Designer, that the updates did not get sent to the base table. I was using TABLEBUFFER = 3-OPTIMISTIC ROW BUFFERING, and TABLEUPDATE(.T.) in my SKIPx commands. I think the TABLEUPDATE only updated the TESTVIEW info with its related cursor info. Is there anything I am missing here or is SEND SQL UPDATES the only thing I need to know?
>
>If you have optimistic row buffering for the view and move through the view records you don't need TABLEUPDATE because when you move off the record it gets updated automatically
Thanks, I just figured that out 20 seconds ago. I wonder why this occurs in VIEWS and not in other TABLES.
Also, do you have any specs or anecdotel evidence on how much faster VIEW's are than the FILTER command? Edward indicates that he uses VIEWs for everything but I already have FILTERs set up so I am trying to decide if I should rewrite:
- all my parent/child stuff;
- just my parent/child grid stuff, or;
- the parent/child code for the grid the one grid I am having probs with.
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