Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record in use error when do SHOW GETS DISABLE
Message
From
26/08/1997 23:06:41
 
 
To
26/08/1997 21:37:45
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00047066
Message ID:
00047075
Views:
17
>Hi All -
>
>I've got a problem that I'm having a difficult time tracking down. I have a screenset made up of 2 screens - sales order header screen is one screen, sales order detail screen is the other screen. If there is one person already in the sales order header screen, the next person that tries to go into that screen gets an error "Record is in use by another" on a SHOW GETS DISABLE command. Several files are open, but only 3 are opened exclusively and none of the other files are locked. Of the three that are opened exclusively, 2 are cursors and 1 is a temporary file stored on the individual user's C: drive.
>
>I have tried SUSPENDING the program when I get the error, then I have tried doing SHOW GET DISABLE for various fields that appear on the screen, but have had no luck finding the problem. Yet when I try SHOW GETS DISABLE from the command window, I still get the error.
>
>HELP! How can I find what's causing the problem? What other techniques do you suggest I use for isolating the culprit?? What exactly will cause the "Record is in use by another" error?
>
>This problem occurs when running on a Novell network or on a NT network, from Win95 or WinNT workstations.
>
>Thanks so much for your help.
>
>Stephanie Allemann
>
>allemann@iname.com


FYI -

I found the problem. 2 of the newest fields that we added to one of the screens was doing a GET directly to the table field rather than storing to a variable and GETting the variable. Changed that and it worked.

Thanks.
Previous
Reply
Map
View

Click here to load this message in the networking platform