>>I have a formset. The first form contains a grid with a summary of all the invoice. The second form contains a master-detail entry form for the invoice.The detail is a grid taking data from a parameterized view. When the user clicks on add button on the first form, I will unhide the entry form. Upon saving, I will hide the entry form and show the summary. I use default data session.
>>
>>Sometimes, when I try to add a new invoice, I get the error 'file is in use by another user'. I am on standalone PC. Can someone tell me why I get this error?
>>
>>My guess is the grid pointer position somehow gets out of synchronization with the parameterized view record pointer. After weeks of suffering, I came out with this! Believe it or not, I just put a messagebox prompt before my 'begin transaction' and it seems to work!
>>
>>I hope someone can give me some clues on why this thing happen so that I can really solve this problem.
>>
>>Thank you.
>
>If you use VFP 3.0 on WINDOWS 3.1, check these parameters:
>In AUTOEXEC.BAT, load the SHARE.EXE as
>SHARE.EXE /F:5120 /L:500
>
>In CONFIG.SYS, add
>FILES = 99
>
>Make FOXUSER.* as read only
>
>I you use memory cache, remove them all from AUTOEXEC.BAT.
>
>Try SET EXCLUSIVE OFF in your main program.
>
>Pierre.

I use win95 & VFP5.0a. I removed FOXUSER.* and SET EXCLUSIVE OFF but it still gives me the same problem.

The problem seems to have something to do with the focus of the grid because I can reproduce the problem easily by doing a combination of 'Calculate ....' and 'append blank'. It seems that after I move my record pointer, 'APPEND BLANK' will give me the error.

I just don't believe I am the only one having all kinds of problem with VFP. Although VFP is rich in features, it is also full of bugs and pitfalls, in my opinions. The learning curve is at least as steep as 60 degrees.