Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems deleting records of a view
Message
 
 
À
06/10/2005 09:21:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01056715
Message ID:
01056719
Vues:
17
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform