Hi,

I just upgraded a system to VFP 9 SP1. The Debtors.DBF table includes the following fields:

clientID C(6)
debtor C(50)
closed D
dDeleted DateTime

And had an index, ID: clientID + debtor + DTOS( closed ) + TTOC( dDeleted )

This worked fine for years (in VFP 8).

As soon as a user attempted to make a change to the closed date, the error:

"Error building key for index "C:\....debtors.cdx" tag "ID"."

I could not reproduce the error in development mode.

After investigating (reindexing, etc.), I changed the index to:

clientID + debtor + DTOS( closed ) + TTOC( dDeleted, 1 )

And this fixed the problem.

Guess something changed in VFP 9 that I wasn't aware of.

No question, just wanted to post this in case someone else has the problem and/or anyone has any input.

J