Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TRANSACTIONS and Record Locks
Message
From
28/02/2000 17:59:42
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00338662
Message ID:
00338757
Views:
18
>>Are you trying to do this on a Novell NOS? You'll have to up the lock count somewhere in the NOS, the default is 500, I think.
>
>
>Fred,
>
>I think we already did update the lock count. We had an issue with Novell 5 and Client32 which we finally solved by upgrading the Client. BTW, this mess only happens when wrapping updates in TRANSACTIONS. Everything seems to go OK otherwise. Weird, ain't it?

No, not really. A transaction tries to do all the updates at once, so if you've really got 1050 records to update, you'd need (at least) 1050 locks. You might need to investigate another method of accomplishing your goal, but it still sounds like a lock count problem to me.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform