>>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?