Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File locking using Sql Update in Windows2003 Server
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
File locking using Sql Update in Windows2003 Server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01532645
Message ID:
01532645
Views:
77
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.
Next
Reply
Map
View

Click here to load this message in the networking platform