Myron

*But* can the same instance of the application have the same table open as is open in an open view?


>The field values are being updated, the indexes do not appear to be updated. This anomoly persist even after the application is closed and the tables are used by other users. The only way to correct the situation is to rebuild the indexes.
>-myron-
>=====================================
>>Myron ---
>>
>>Is it possible that you have the base table explicitly open and buffered as well? If so, if you issued a TABLEUPDATE() on the base table *after* you had on the view, changes via the view may be overwritten.
>>
>>
>>>I have a view consisting of 4 tables that updates 1 of the base tables. The view is being used on a form to update 3 fields. The problem is that the view commits the changes correctly but the update tables indexes apparently are not being updated correctly. After the update is made I can go to the base table and see the changes but when attempting to try to do a SQL Select with a Where statment based on the field value, the record is not selected.
>>>
>>>If I manually change the field to a different value and back to the changed value it will start working correctly. As a work-around I have had to save the updated value and the OLDVAL of the view and then update the base table with a REPLACE statement with the OLDVAL and then the new value.
>>>
>>>Also, if I delete and rebuild the indexes with the new values are then corrected.
>>>
>>>VFP5.0b on WIN98 and WINNT.
>>>
>>>Thanks,
>>>myron kirby