I just ran into a very strange thing. A piece of code that has been out there forever suddenly stopped working properly.

I had code like this:

SET SAFETY OFF
Create table SomeTable ;
    (field1 C(10), ;
     field2 C(15), ;
     .
     .
     .
     )

Create table SomeOtherTable ;
    (field1 C(7), ;
     field2 N(4,0), ;
     .
     .
     .
     )
SET SAFETY ON

SELECT SomeTable
Index on SomeTable.Field1 tag field1
Index on SomeTable.field2 tag field2

SELECT SomeOtherTable
Index on SomeOtherTable.Field1 tag Field1
Index on SomeOtherTable.Field2 tag Field2

Select SomeTable
Append From SomeText.txt Type Delimited With Character "|"

Select SomeOtherTable
Append From SomeOtherText.txt Type Delimited With Character "|"

For some reason, suddenly not all of the text file records are appended. This has worked fine for the past couple of years. This was noticed when we upgraded the client to version 9 of the VFP runtimes and the code was recompiled using version 9 SP1.

Now, if I change the code so that the index creation lines follow the appends, then it works perfectly again.

Has anybody run into this beast before?