Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File locking using Sql Update in Windows2003 Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
File locking using Sql Update in Windows2003 Server
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01532645
Message ID:
01532645
Vues:
76
I have a problem and I am seeking a little help. I have an application that's trying to do 13000 Sql Updates in a transaction to 2 tables. It runs fine for about 2000 or so updates and then hangs. When I check the server for file locks, I notice that there are 2000 or so locks on each file. I cannot identify what's causing this and I am wondering if there is a lock limit on the server that maybe an issue here? Thanks in advance for any help.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform