>>I have a form with 3 views and a table that has a problem with it's data environment loading the views.
>>"Error loading file - record number 7. frmClientActivityReport
. Loading form or the data environment: Index does not match the table. Delete the index file and re-create the index
>>
>>Method: CAPPLICATION.DOFORM
>>Line: 41"
>>
>>The form has 3 views which are based on our SBT Accounting Systems files....
>>and a table of it's own
>>
>>Any ideas what's wrong or what to do?
>>
>>Rick Liebespach
>
>Sounds like you'll have to do what it says and delete the index file and recreate it.
>I'm unfamiliar with SBT, but they should have a database maintenance routine built in that should fix this sort of thing for you. (Like I said, though, I'm not familiar with it, so don't quote me <g>)
----------------------------------------
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: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 ADDITIVE
I originally created this file in "the usual way" and it was a part of the DBC. I add the maintenace routine to delete and rebuild it, because of this problem....but it hasn't worked long term...just short term...
now I've removed it from the dbc and the form's data environment and create it with the lines above...
It seemed to work but crashed on the report and the data file seems empty...but a spreadsheet I export from it has data......weird.
Rick
---------------------------
