Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems deleting records of a view
Message
 
 
To
06/10/2005 09:21:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01056715
Message ID:
01056719
Views:
16
A view cannot be w/o buffering and default is optimistic row buffering. It would be better to use SPT to delete so many records.

>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) ?
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform