Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index tag is corrupted starts to occur month ago
Message
De
18/08/2013 06:16:47
 
 
À
17/08/2013 17:23:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01580698
Message ID:
01580718
Vues:
59
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform