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