>I apologize for not reading your question more thoroughly before responding initially. "Occupational hazard" (dyslexia). :-)
>
>Looking at DTOC() function VFP9 SP2 help:
>
>
DTOC(date[,1])
>1 - Returns the date in a format suitable for indexing. This is particularly useful for maintaining the table records in chronological sequence.
>For example, to order table records in entry sequence, you could issue this command:
> Copy Code
>INDEX ON DTOC(gdInvDate, 1) + gnInvTime TAG Timeindx>
>As for the reason you're getting the error ... odd.
>
>Try LIST STATUS TO file1.txt from the place it fails, and LIST STATUS TO file2.txt from the place it succeeds, and do a diff on them. Maybe there's a spurious setting cropping up somewhere.
>
>I've never seen that before. Only on memo fields, or conditional IIF()s that were wrong.
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 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?
Tommy Tillman A+ NetWork+ MCP