It's not recomended to include table name in the index expression. Try

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

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

>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?