Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem Multiusers Access the same table
Message
From
08/07/2005 17:41:47
 
 
To
08/07/2005 11:22:09
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01030214
Message ID:
01030791
Views:
15
>Ahmad,
>When they save their data, can you do a refresh of the data table directly before you do the table update?
>Create a cursor that has all of the necessary fields for input. Then, in your save method, scattermemvar, select table for update, append blank, gathermemvar.
>
>I do not have as much experience as many on this forum. Please test carefully before implementing.
>
>Hope that gets you on the right track. Or, helps atleast.
>
>
>>HI all
>>
>>I have a problem when 2 users enter the same form ; User 1
>>entering data at the same time and when user 2 saves the record user 1 sees
>>that record instead of the one they've saved.
>>
>>Thank you in advance
>>
>>
>>Best regards
>>
>>Ahmad Zrein
Sorry about re-posting ontop of my first message but, also look into RLOCK() and FLOCK functions. Those could help with your predicament as well.
Thanks,

Chad
Previous
Reply
Map
View

Click here to load this message in the networking platform