>>>>Here is the index key Unassdoc
>>>>
>>>>“DTOC(when_sent)+doctor_last_name” (when_sent is a datetime field) (doctor_last_name is C(35))
>>>>
>>>>And the Filter is “status = 5” for this key
>>>>
>>>>There are NO Memos in this key.
>>>>
>>>>I can go in and Rebuild Indexes, and sometimes this fixes it. Then when I run the code, the error reoccurs.
>>>>
>>>>
>>>>Since there are NO Memors, then why would the error occur.
>>>
>>>Don't use DTOC function in the index. Use DTOS() instead. Check DTOC() in Help as to why (you can use it with second parameter).
>>
>>Hi Naomi
>>
>>I just saw this this morning.
>>
>>I was already testing changing the DTOC to DTOS in all the tags in the offending table ss_io.dbf.
>>
>>After changing them, the error went away. So........ I wondered.........
>>
>>I put back in place the old code with the old table with the DTOC in it.
>>
>>I ran it against my old EXE, that was compiled in VFP 8.0 Service Pack 1 and it ran fine.
>>
>>Replacing the EXE with a newly compiled version in VFP 9.0 Service Pack 1, and it failed again. Go back to the old version, it works. Back to the new it fails.
>>
>>So....... someting in VFP 9.0 Service Pack 1 fails in the Index Tag if you use DTOC against a datetime field.... also, there is a built in filter with the tag too.... "status = 5" for the filter. If it helps in understanding this error.
>>
>>So....... I have gone ahead and changed the index to get rid of the offending error.
>>
>>What do you think?
>
>VFP 9 is more strict for the index expressions. You should never use functions that may produce different output depending on local settings. Help to DTOC function explicitly states it.

I never saw any prohibitions on using DTOC in tags. I was looking in the VFP 9.0 help.

Thanks!