Well we got it working!
Thanks for your input!
I ended up removing the offending table from the DBC. I also removed the additive from the index.
Between those two things the application is now working as desired.
Thank you.
Rick
--------------------
>Does this table persist once it's created the first time, or does it get created every time?
>
>Major SWAG:
>It could be that the CDX file is still out there for it when it gets recreated and then, of course, it wouldn't match the index since the table is now empty.
>
>Before creating the table, you might try getting rid of all files for this table first, like in the bolded code below...
>
>2nd SWAG:
>Take out the ADDITIVE from the INDEX command. That only seems to be necessary when using IDX indexes, which you wouldn't be because you're using INDEX ... TAG and not INDEX... TO.
>It shouldn't be the cause, but like I said, it's a SWAG.
>
>>Upon closer inspection it's not the SBT tables I've got the problem with, but rather the view I've created to contain the report results.
>>
>>Even tho I have a maintence routine of my own I've still got a problem.
>>
>>The file it's complaining about is the one I re-create upon request with the following code:
>>
>>
>IF FILE("data\clientstatus.dbf")
> ERASE data\clientstatus.*
>ENDIF
>
>>CREATE TABLE DATA\ClientStatus ;
>> (CUSTNO C(6), ;
>> OMNIA_CUST C(15), ;
>> COMPANY C(35), ;
>> CODE C(2), ;
>> ENTERED D, ;
>> STARTDATE D, ;
>> ENDDATE D, ;
>> RUNTIME T, ;
>> SALESMN C(15), ;
>> YTDSLS Y, ;
>> REVENUE Y, ;
>> INVNO C(10), ;
>> INVDTE D, ;
>> INVAMT Y, ;
>> BEGINACTIVE L, ;
>> BEGININACTIVE L, ;
>> BEGINZERO L, ;
>> ENDINGACTIVE L, ;
>> ENDINGINACTIVE L, ;
>> ENDINGZERO L, ;
>> NEWACTIVE L, ;
>> NEWZERO L, ;
>> ZERO2ACTIVE L, ;
>> INACTIVE2ACTIVE L, ;
>> ACTIVE2INACTIVE L, ;
>> STATUS_SET C(20))
>>
>>INDEX ON custno+DTOS(invdte) TAG CUST_INVDT
>>>>
