>>I've never seen that before. Only on memo fields, or conditional IIF()s that were wrong.
>
>I ran it against my old EXE, that was compiled in VFP 8.0 SP1 and it ran fine.
>Replacing the EXE with a newly compiled version in VFP 9.0 SP1, and it failed again.
>Go back to the old version, it works. Back to the new it fails.
>
>So....... someting in VFP 9.0 SP1 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?
I think it's weird. :-)
I have not seen this issue previously, but I don't know if I've ever used DTOC() on datetime.
I probably would've used:
SUBSTR(TTOC(ltWhatever),7,4) + LEFT(TTOC(ltWhatever),2) + SUBSTR(TTOC(ltWhatever),4,2)
because I didn't know about the extra flag in TTOC() LOL! So, it likely would not have been an issue. :-)
I am curious if you use:
INDEX ON LEFT(TTOC(ltWhatever),10) TO whatever.cdx TAG whatever FOR status = '5'
if it does the same thing in VFP9SP1?