Igor,
>1.The default record locking for Framework is optimistic. If we will change it to pessimistic does the Framework will continue working correctly the way it was or something will go wrong?
The Framework is designed to handle both...if something doesn't work, I'd sure like to know about it < s >.
>5.Would be interesting to know what Kevin thinks about it.
I tend to discourage the use of pessimistic record locking...one of the reasons is that VFP does not support pessimistic locking on remote cursors...so, although pessimistic locking will work with your VFP data, if your app scales to client server, you'll need to use optimistic locking...based on this, I recommend using optimistic locking where possible. Check out the VFP help topic "Updating Remote Data with SQL Pass-Through" for details.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com