>>Hi Al,
>>
>>Here's a really weird thing:
>>
>>1) Create a table eg Table1.dbf with some fields.
>>
>>2) Make a copy of this table and call it, say, Table2.dbf.
>>
>>3) Open Table1 in an instance of VFP8 or VFP9 (didn't try with anything else).
>>
>>4) Browse the table. Obviously its empty.
>>
>>5) Open another instance of VFP.
>>
>>6) Open Table2 and add some records to it.
>>
>>7) Close Table2 (USE) and copy it over Table1: COPY FILE Table1.dbf TO Table2.dbf. Remember that Table1.dbf is
still open in the first instance of VFP.
>>
>>8) Switch back to the first instance of VFP and the browse of Table1 which is still empty, as expected.
>>
>>9) Now just issue the BROWSE command again on Table1 and presto the records in Table2 that were copied to the
open file Table1 appear in the browse window. Weird??
>
>That's almost exactly what the repro code in my first post illustrates. The difference is that my code closes, then re-opens the overwritten table, while you simply issue a BROWSE.
Hey Al. Yup, sorry I didnt read through your code properly but yes its virtually the same. Very strange especially when the two tables even have different file structures :)
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.