Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index key build error in temp report
Message
 
À
04/05/2011 08:34:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01509359
Message ID:
01509677
Vues:
51
>Is EmpNo the same length as sName + FName? If not, you're asking for trouble as it will create a variable length key and VFP doesn't like that.
>
>>I have some report generation code that has worked under VFP7 for years, but now gives me an "error building key for index [cdx filename] tag [tagname] under VFP9.
>>
>>the code pointed to in the debugger:
>>index on iif(eof('PERSONEL'),EMPNO,PERSONEL.SNAME+PERSONEL.FNAME)+dtos(date)+DUTYTIME+EXCCODE tag REPORT
>>
>>If I suspend the program and then immediately resume, the error disappears. I assumed that it may have been an issue with data in memory not yet written to disk, so I added a flush command - no luck, neither did a wait statement.
>>
>>If I run the same process in VFP7 there is no error or issue.
>>
>>I'm using XP SP3, 2Gb RAM and a 2.7Ghz CPU.
>>
>>Any suggestions would be very welcome....

EMPNO C(5), SNAME C(20), FNAME C(20)

I see your point, tks.
The routine seems to have worked just fine for 15+ years...
However, I have now removed the iif part and made it sname+fname+empno and VFP9 seems much happier now.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform