>>Agnes,
>>
>>>Can an you reproduce this
>>Yes, I even tried with a function that is not a stored proc. A function that calls another function doing try/catch. And lastly without try/catch and with on error ...
>>
>>
>>>How can I work around
>>
>>I haven't found any way. Appears that any error in the append will say 'record in use'
>
>Hmm, when I first read this I saw TEXT TO... with TRY...CATCH. I ran into an error with this a while back - Message#
1412669 so I thought it might be related.
>
>Then I saw you've tried other scenarios and still see the problem.
>
>The problem I ran into is caused by an error condition stomping on an open file handle, Christof offered a workaround, which was to store the file handle to a memvar, then restore it after the error handler has completed.
>
>So, I'm wondering if Agnes' problem is also caused by the VFP error handler stomping on something it shouldn't. Maybe if that could be saved, then restored after the error was handled, it would be a workaround.
>
>What it might be that should be saved, I have no idea :(
>
>The problem I encountered was in VFP9 SP1 but not in VFP8 SP1. I wondered if this issue was also not present in VFP8 SP1.
>
>I ran Agnes' code on VFP8 SP1, no problem found, 2 records are appended, no error is raised.
>
>I've also run it on VFP9 SP2 7423 (latest hotfix), no problem there either (?!?)
I can reproduce the error with.
Visual FoxPro 08.00.0000.3117 for Windows,
Visual FoxPro 09.00.0000.3504 for Windows (SP1)
and
Visual FoxPro 09.00.0000.7423 for Windows (SP2)
The
TEXT TO is totaly unrelated, it was used to create the SP only.
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]