>According to the help: "If the table you specify isn't open, it is opened
exclusively in a new work area..." The emphasis is mine.
>
>I hadn't noticed this before (I use APPEND BLANK + buffering most of the time); but now I ask: wouldn't this be problematic for multiuser applications?
>
>Is this behavior still so in later versions of VFP?
>
>Must the programmer always include something like the following?
>
>
>if not used("MyTable")
> use MyTable again in 0
>endif
>insert into MyTable...
>
This is from VFP8 Help:
If the table you specify is not open, Visual FoxPro opens it in a new work area, and the new record is appended to the table. The new work area is not selected; the current work area remains selected.
If the table you specify is open, INSERT appends the new record to the table. If the table is open in a work area other than the current work area, it is not selected after the record is appended; the current work area remains selected.
In other words, no mentioning of exclusive anymore.
If it's not broken, fix it until it is.
My Blog