Sorry Sergey, the parameter is new to me <s>

I believe error 2199 is new to 9.0, correct?
The parameter may not be new, but the required use of it with an index with DTOC() in the expression is new.

It probably should have worked this way all along and I should have been using the parameter with DTOC() or DTOS() as you suggested.


My problem the other day felt similar to what Frank is describing. We could not reproduce the problem easily either. It only occurred on certain testing data sets and reindexing seemed to fix the problem.

The system would not allow records to be added.

The index expression worked fine in 8.0 with no error, now it breaks in 9.0
(error 2199 when attemting to add a new record)

DTOC(dcreated)


After i changed to DTOC(dcreated,1) I am able to add records for all testing data sets again without error. It is curious to me why this worked on certain data sets but not on others...


I thought it may be possible that Frank had an index on DTOC() in his table...



>>Another way to get around this for version 9.0 is to use the new parameter with DTOC() when building your index expression.
>>
>>dtoc(dfield,1)
>
>New? :)
>It has been available since Fox 2.6 at least. It also known as DTOS().