Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiuser environment and =TABLEUPDATE(.t.)
Message
 
 
To
10/03/2010 09:53:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01453721
Message ID:
01453722
Views:
62
>=TABLEUPDATE(.t.) problem when in multiuser environment.
>I am using some some in to update auto referencing.
>
>When first user logs into a screen he gets the next auto reference correctly i.e AB130 and the code has a =TABLEUPDATE(.t.) at this point and he starts to fill in the screen, the second user goes into the same screen and gets the next auto reference AB131 also correct and same code =TABLEUPDATE(.t.).
>The first user clicks save and table is saved with correct values i.e auto ref AB130, then clicks new screen again but instead of getting the next auto reference AB132 he gets AB131 which is being used by the second user so when he has filled in the screen and clicks save, he gets duplicate reference message which is correct.
>
>My question is why is the reference AB131 not being saved to give me the next correct auto reference?. How can I get it to commit in multi user environment?
>
>Thanks

Can you use all parameters in tableupdate command, check its return status and check with aError what errors you're getting?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform