Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking SQL Server?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00002740
Message ID:
00002741
Views:
42
>Hello. I use VFP as front end to connect with MS
>SQLServer. Is there any way to lock the database
>for me only (like flock() in FoxPro? I know that
>SQLServer use automatically lock. However, is
>there any tricks?

Pium

Do you mean Database or Tables? If you mean Database then sue it excluseively. If you mean tables then look at Pessimestic buffering.

HTH
Tom
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform