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....
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer