Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index tag is corrupted starts to occur month ago
Message
From
18/08/2013 06:16:47
 
 
To
17/08/2013 17:23:53
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01580698
Message ID:
01580718
Views:
60
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform