Swee,

When VFP opens files that have a CDX file with them, you don't need set index to, just SET ORDER

Assuming you have a customer table with the following indexes within a .CDX
use customer excl
index on lastname + firstname tag bylastname
index on socsecnum tag socsec
index on homephone tag homephone

then you can
close all
use customer (the .cdx file will automatically open with the file)
set order to bylastname
or
set order to socsec
or
set order to homephone


>Hi,
>
> I am converting three clipper 5.2 application to visual foxpro 5.0 code. I had this problem of SET INDEX TO,
>
> The clipper code is
>
> USE
> IF !NETERR()
>
> SET INDEX TO
>
> ELSE
>
>
> ENDIF
>
>
>
>So, when I change the code to
>
> SET INDEX TO OF
>as all the index files are already in CDX format, but the compiler complaint of not able to find the NDX index file. I had even tried to use SET INDEX TO , but in vain.
> In addition, which command or instruction is good for me to help me in replacing the clipper NETERR() function which check whether the table file is open successfully. Any help or suggestion or advise is very much appreciated. Thank you.
>
>Best regards
>Virusim