Visual FoxPro 09.00.0000.5815 for Windows
I have a table with several indexes that are set as unique.
These indexes have been in place for several years.
Just recently when issuing an append blank I get the error <error building key for index workdate.
The index definition is: workcode + dtoc(invodate) - workcode is C(17) and invodate is D.
The is a flock() placed on the file just prior to the append blank.
If I open the same table in a vfp session I can append blank all day.
Not sure where to go next with this issue.
Need to resolve a.s.a.p..
I have done several selects to weed out any invalid dates etc.
Tried the same code on different workstations.
But still the problem remains.