>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only