General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only