>hi all,
>
>i have a problem with a view. It's a view on a sqltable. When i load the view it contains aprox 14.000 records. When i enter 'delete from myview' in the vfp command window my vfp stalls. Is this view to big for datahandling or could there be another problem (there is no buffering on my view an anyway) ?
>
>thnx.
try:
CURSORSETPROP("Buffering",5,"view")
CURSORSETPROP("BatchUpdateCount",100,"view")
delete from myview ....
deleteresult=TABLEUPDATE(.T.)
....