Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locks, wthat is the better option ?
Message
From
21/04/1998 18:56:31
 
 
To
21/04/1998 14:08:12
Carla Silva
Http - Produtos Informaticos, Lda.
Odivelas, Portugal
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00093756
Message ID:
00093846
Views:
29
>What is the better option to programming in network data sharing:
>
>1) Using the scatter and gatter command, and manually locking, using the rlock() , flock() and isrlocked(), set reprocess, ......
>
>2) Using the buffermode property, and this way use the tableupdate() , tablerevert() , begin transaction,.....
>
>I´m using the dataenvironment, datasession property type 1, buffermodeoverride property type 3.
>
>Thanks
>Carla

If you're working with tables in the DataEnvironment -and- fields from those tables are mapped to control.ControlSources you almost have to use buffering. In those cases, I usually set the Form.BufferMode to Optimistic and set the tables to use the Form's setting.

Just be sure you wrap tableupdate() into a BEGIN..END TRANSACTION block with plenty of error trapping.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform