Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index key build error in temp report
Message
From
05/05/2011 12:58:51
 
 
To
04/05/2011 08:34:44
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01509359
Message ID:
01509677
Views:
49
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform