Let me first clarify that this is a problem I am having in FoxPro 2.6, not Visual FoxPro.

I am having a problem with record locking when exiting a screen. Upon exiting the screen, I check to see if any records meet certain criteria and if they do perform a minor update to each of these records.

The background of this problem is that I have 2 maintenance screens which use the same file. The one screen uses the file with and index set and a for condition of NEW='N' (therefore the records meeting this criteria appear on one screen and the remaining records appear on the second screen). When all of the required information has been entered, I replace the NEW field with spaces so it will appear in the second maintenance screen.

With that description, allow me to show you the piece of code I am using:

REPLACE ALL new WITH ' ' FOR new='N' AND NOT EMPTY(fund_acct) AND reccost=.T. AND recsign=.T.

Just to give a little bit more insight (and to complicate matters more), I manually located one of these records and manually typed the command (without the 'all') and I received the same message (attempting to lock...). However, I am able to edit the record (i.e. add comments in the comments field) and I do not receive the error message.

Next, I tried to physically go in and hit the spacebar (to delete the 'N' in the field new) and it allowed me to do this. It also allowed me to manually type the following command from the command box without receiving the error:

REPLACE NEW WITH ' '

Any thoughts would be greatly appreciated. Thanks.