Hi David,
Very good point. Thanks a lot for this advice.
>Nadya,
>One thing you might consider in your code is whether the records you're appending originated from a simple cursor. Simple cursor may not be the correct terminology but a simple cursor's records can come from a single table. These record are kind of directly linked to the table they came from. To demostrate, keep a simple cursor opened in the datasession but close down the original table. Now try opening that table back up,... you cannot, the error you will see says 'table already in use'. If you close down your cursor then everything is ok. My point here is that if you use the dbf command with a simple cursor FoxPro may try to append all the records from the underlying table instead of the cursor. To make it work the way it should include for example recno() in the field list of your sql. This will ensure the cursor is not simple one and the dbf command will work properly.
If it's not broken, fix it until it is.
My Blog