>>I am afraid Naomi is 100% correct here, dont use dtoc() in your index, use dtos()
>>which secures a correct index and dtoc() not, also read the help file about dtos().
>
>
>Koen, you misunderstand. You left out the important part:
>
>>>I'm still not understanding the cause of Tommy's error outside of a bonafide
>>>bug in VFP9SP1.
>
>The issue is that Naomi and Doug are saying DTOC() was changed in VFP9 to cause an error and prevent indexes from being created in the first place because that function could potentially produce variable-length keys based on settings like SET CENTURY.
>
>My issue is: I have not seen this in practice and am inquiring how they make such claims. I assume I'm missing something obvious but ... I am currently missing it.

Rick

Naomi said quote
it doesn't make sense to use DTOC as is anyway, because the rows will not be properly sorted.
unquote

on which you replied with
quote
INDEX ON DTOC(dMyDate)...
and it will create a properly sorted index.
unquote

so my thesis is:

Naomi is 100% correct - one is not suppose to use dtoc() in an index expression, use dtos()

please note correctly.

Regards,

Koen