Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View in multiuser env
Message
From
30/08/2001 09:06:21
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
29/08/2001 12:06:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00550368
Message ID:
00550809
Views:
24
>I must to append or delet the records from different stations in same time
>I have ~300.000 recs.

Since you apparently need shared access, you can some combination of optimistic buffering, transaction, and record locking.

Optimistic buffering - and checking for the result of TableUpdate() - is enought in most cases. Transactions are required if you want to do changes on several tables, and make sure that either all or nothing is saved.

Record locking is seldom required any more with VFP.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform