Hi all,
First off, thanks very much to all who wrote with suggestions. The problem is now fixed. For those who may be interested, here's what I did:
As I said, the error message I was getting (in 6.0) was:
Record is use by another user
Since there was no other user in the system (I was doing this on a non-networked stand-alone notebook), that was very confusing.
I just got 9.0 and installed it. I ran the system I'm talking about through 9.0, and was given a different error message in the same spot:
Cursor cannot be modified because it contains an unsaved record
Now, THAT made a lot more sense. I added a tableupdate(.t.) in my code after finishing up the record I was using and before adding the new record, and everything works beautifully now.
Again, thanks to all who have helped. I hope what I posted above helps someone.
Get ready for a whole new batch of questions from me once I get into 9.0. ;)
John
>This is a known problem when trying to move the record pointer with a gridcell beeing active. The best remedy might be to do this in a different alias based on the same physical table or cursor, or get the focus off the grid before doing the replace.
>
>Walter,
>
>
>>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.
>>
>>Any pointers?
>>
>>Thanks very much!
>>
>>John