Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiuser Misery
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00533710
Message ID:
00534038
Views:
12
>Frank:
>
>Your workaround does the trick. Thank you.

Glad it work out.

>
>I have one more question. Do I have to be concerned with two users adding records at the same time? The Programmer's Guide says that if two users APPEND BLANK simultaneously, it will cause an error since the file is locked during an APPEND BLANK. I ran two instances of my application, clicked on the "Add" button which essentially appends a blank record to the buffered table without saving it and then did the same thing in the other instance. I was then able to "Save" both records to the file without conflict.

Only when the issue the command APPEND BLANK, the table header is locked so they have to have to add a record at the same time to get this error. Of course when you trap the 'File is in use' error and try again it will work the second time, because the odds of getting the same error is slim. (In your case with such a small userbase, if it gets bigger, I would suggest that you get more optimistic)

>Jay
Frank Camp
Previous
Reply
Map
View

Click here to load this message in the networking platform