General information
Category:
Forms & Form designer
>>>Two questions:
>>>1) Do you delete/add to view or to underlined table?
>>
>>I both delete and add to the underlying table, not the view. Then I issue "=requery('myview')" and grid Refresh commands to update the view.
>>
>>>2) Is inderlined table buffered?
>>In the main form where I delete records from the base table, the BufferOverrideMode is set to 1 for all associated tables/views.
>>
>>In my "Add a new contact" form, the BufferOverrideMode is set to 4. In the form's Init method, I add a blank record with a new key field value and default values in the other fields. Then when the user has selected a person and position from my dropdown boxes for the new record I issue a:
>> =tableupdate(1,.t.,"contacts") command
>>to update the table.
>>
>>I'm not incredibly sure how buffers work. Could this be my problem??
>>
>>Many thanks!
>>Mandy
>
>Firstly, the more natural way is to work (add/delete records to view). Also, BuffermodeOverride=1 just indicates that DE objects inherit buffering mode from Form.BufferMode setting, so check what you have there. Also, BufferModeOverride=4 (pessimistic table) is awfully awkward for real multi-user interface.
>Normal setting is following: table-buffered view and non-buffered underlined table.
I gotta tell ya, Edward, I love ya! Once again you were correct and my problems were with the table buffering that was going on with my "Add a new contact" form. I disabled them and she's working like a charm. Just thought I'd pass along the good news.
Thanks again!
Mandy
Previous
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