>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