Currently, we encounter problems with PC/FOCUS 6.01.1.

1. Is the file corrupted (see the message below) because we have problems with insert or update? Need to rebuild? Do you have any rebuild instructions?

>>? FILE REFUND95

STATUS OF FOCUS FILE: C:\focus\REFUND95.FOC ON 04/05/06 AT 16:15.10

ACTIVE DELETED DATE OF TIME OF LAST TRANS
SEGNAME COUNT COUNT LAST CHG LAST CHG NUMBER

MONO 2902 04/05/06 16:15.10 1
SEC 14191 04/05/06 16:15.10 1

TOTAL SEGS 17093
TOTAL CHARS 1434412
TOTAL PAGES 398
LAST CHANGE 04/05/06 16:15.10 1

FILE APPEARS TO NEED THE -REBUILD- UTILITY
REORG PERCENT IS A MEASURE OF FILE DISORGANIZATION 0 PCT IS PERFECT--100 PCT IS BAD
REORG PERCENT 65.01 %

2. Is there a limitation or restriction how many records can be created by using 'On table save'? I know it should have more than 146 records in the file refund95. Is this how to export PC FOCUS file to an Excel file? Any other command?

>>table file refund95
TAB>print *
TAB>on table save
TAB>end
MERGE: RECORDS= 146 LINES= 146

NUMBER OF RECORDS IN TABLE= 146 LINES= 146


ASCII RECORD NAMED SAVE

FIELDNAME ALIAS FORMAT LENGTH

PARCEL PAR A10 10
SS SS A2 2
GDD GDD A1 1
LNAME LNAME A18 18
FNAME FNAME A32 32
NUMBER NUMBER A8 8
STREET STREET A30 30
CITY CITY A18 18
ZIPCODE ZIP A5 5
MNUM MN A8 8
MST MST A30 30
MSTA MSTA A2 2
MCITY MC A19 19
MZIP MZIP A5 5
UNIT UNIT D4.1 4
HAULER H A20 20
HFEE HFEE D7.2 7
SDATE SDATE MDY 6
TEL TEL A10 10
FY FY A2 2
RDATE RDATE MDY 6
PDATE PDATE MDY 6
AMOUNT AMOUNT D7.2 7
RECYC RECYC A1 1
GREEN GREEN A1 1
CONT CONT A1 1
REM1 REM1 A30 30

TOTAL 289

DEFAULT FILEDEF ISSUED
FILEDEF SAVE DISK SAVE FTM C:.\
HOLDING...
>>

Any help will be really appreciated.
Thanks.

1) Just REBUILD the file using

REBUILD FILE REFUND95

Do a REBUILD / REBUILD with no record selection tests and it should be ok

2) TABLE FILE REFUND95
PRINT *
ON TABLE HOLD AS HOLD1 FORMAT EXCEL
END

Course this depends on the structure of REFUND95, ie if its single segment file etc