Xavier,

I'm not sure what's going on here. I would try setting the buffering to 5. Then, after you delete all the records do a TABLEUPDATE() (make sure that TABLEUPDATE() returns .T., otherwise an error was encountered). Then insert all the new records and do another TABLEUPDATE().

>Hi Josh,
>
>I appreciate your support, I have set all my views to share connection and fetchsize to -1. I do not get the connection busy anymore but I get UPDATE CONFLICT from time to time using the same data so the data are valid.
>
>The program execustes as follow
>Select the view
>Delete all record
>insert all record from an other table
>
>It seems to me that the delete does not complete its task or can not event start it from time to time.
>
>When I select the view is there any chance for the program to start the delete before all records are retreived ?
>
>Should I set the views buffering to 5 rather than 3 ?