How do you know that one record is being updated at a time and that the view is being requeried each time? Also, see my other reply about indexing.

>Josh,
>
>I found part of the problem, the view was NOT buffered as I thought, it is now.
>The current problem, now when I do a TABLEUPDATE(.T.) one record at a time is updated and the view is Requeried each time.
>
>What am I doing wrong???
>
>TIA
>
>Rex
>
>
>
>>Rex,
>>
>>Do you have indexes on the field(s) that make up the primary key for the underlying table?
>>
>>>All,
>>>
>>>I have an application that uses a view. I open the view NODATA and set buffering to optimistic table buffering add some indexes and requery the view..
>>>
>>> I then allow the user to select records and I replace a flag field and print the records. I then replace several fields in the view with pertinent information for all selected records. During this replace, for each record, the view requeries. It takes 120 seconds ro update one record and then it goes to the next record and takes another 2 minutes and on and on...
>>>
>>>Has anyone seen this behavior???
>>>
>>>Thanks
>>>
>>>Rex