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.
Thanks as always Edward! I'll give it a whirl! :)
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