>>SQL-insert command is capable of inserting records into a table which wasn't opened - it can open it. You only need to supply a name it can use to open it - a sufficient path, or dbc!table syntax for an already open DBC. In the simple cases (filename equal to alias and visible on set("path")) it just works without need to explain. The need is there for weirder cases :).
>>
>>If table was already opened without buffering, now that may cause the error above. Or if it wasn't opened and VFP opens it without buffering by default (which would then defeat the purpose of the smart opening).
>
>Not sure what you mean by "smart opening".
What I said about Insert command opening the table where the filename may be implied in several ways.
>There are other tables open with buffering set to 3. Since this is an insert and not an edit I assumed buffering is not needed for this table. Plus we want the code to work whether the table is previously opened or not. Hence the syntax that includes the dbc.
Which is all fine, it's the error message that really shouldn't happen. Is there a tableupdate() implied somewhere (via trigger maybe)?