Make sure that CPDBF() = CPCURRENT(). You can use cpzero.prg from VFP Tools\Cpzero subdirectory to change DOS table codepage.

>A really weird problem. I have a Foxdos table with some simple indexes stored in a CDX file.
>
>orderno index on orderno
>custno index on custno
>trandate index on trandate
>
>Here is the weird part. I try and run a SQL against the table in VFP9 and it is slow. I check with SYS(3054) and it says optimized is none. My SQL is very simple such as.
>
>Select *;
> From testtable;
> Where orderno="1234"
>
>Yet if I change the above field from orderno to trandate it becomes fully optimized. So VFP9 can use Rushmore from Dos, but not on strings.
>
>Any ideas on what I might be missing.
>
>TIA,
>Dale