The following index in VFP9.0 beta worked fine when doing an insert into the table:


ALLTRIM(STR(add_type))+DTOC(startd8)+ALLTRIM(STR(fk_patients))

where add_type is an integer field,
startd8 is a date field,
and fk_patients is an integer

Today, I finally downloaded released VFP9.0 and am getting the following error:

"Error building key for Index ..."

Removal of index program runs fine and then adding index back in seems to work.

Can anyone give me a hint as to why the above index is giving me trouble?

Thanks in advance