>Is this the only index tag? If not, what expressions do you use for the other tags?
In one site error index tag ISIK in table PUHKUS is corrupted and last entered records are not found before index is re-created.
Indexes on puhkus table are:
index on isik+sys(11,palgus)+kood tag PALGUS
index on isik tag ISIK
index on 'P'+str(reanr,7) tag REANR
All tables have fox2 structure. After those create tables they are converted to fox2 dbfs.
code pages in table headers are set to 0 and code page conversion is turned off.
Table structure is:
create table _PUHKUS ( ;
REANR N(7), ;
ISIK C(10), ;
;
KOOD C(9), ;
ALUS C(20), ;
ISIKUKOOD C(19), ;
;
SAADAPP N(5), ;
ARVPALGUS D, ;
PALGUS D, ;
PLOPP D, ;
TASUTA N(3), ;
PROTSENT N(3,0), ;
KASKKIRI C(8), ;
PPERALG D, ;
PPERLOPP D, ;
;
KLIENT C(12), ;
KULUKOHT C(15), ;
KULUOBJ C(10), RID2OBJ C(10), RID3OBJ C(10), ;
RID4OBJ C(10), RID5OBJ C(10), RID6OBJ C(10), ;
RID7OBJ C(10), RID8OBJ C(10), RID9OBJ C(10), ;
;
VMNR N(6) )
Andrus