Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record In Use By Another User...but I'm the only user!
Message
From
22/07/2006 23:12:52
 
 
To
21/07/2006 20:21:28
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01138768
Message ID:
01138869
Views:
11
>Hi all,
>
>I'm struggling with another problem on an Order Entry form. After the user enters all header information, it moves to a grid for them to enter their detail lines. In the Valid method for column-8 of the grid (the last column in the grid), I have it calling a method I created to add a new detail line. When I move to that detail line, I'm getting:
>
>
Record is use by another user
>
>I'M THE ONLY USER!!! :) I'm doing this on my notebook which is a stand-alone machine and not connected to any network.
>
>In the Valid method for column-2 of the grid, I have the following code:
>
>
>seeker=ord_line.cust_part+str(ord_head.cust_no,6)
>if indexseek(seeker,.t.,"partchrt","cust_part")
> newpart=partchrt.usmc_part
> repl ord_line.usmc_part with newpart
>else
> repl ord_line.usmc_part with spac(10)
>endi
>retu
>
>
>The line that begins with "REPL" is the one that's causing the error to occur.
>
>I also will see the occasional message in the bar at the bottom of the screen that says "This record is read-only." When that happens, for some reason, I lose my ability to Tab through fields in the grid...I have to use the mouse to click to different fields.

Sounds like the table is open in another datasession, and in that datasession either an explicit or implicit FLOCK() or RLOCK() is happening. Note that SET EXCLUSIVE, SET MULTILOCKS etc. are scoped to a datasession (i.e. not global).

Another possibility is if you've USEd < the table > AGAIN. Yet another is that a SELECT - SQL has opened the table unexpectedly.

Firing up the debugger can help in these cases.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform