I always have index keys even I use Locate, I thought VFP will use the index keys for the Locate as well.

in case I want to change to Seek, what should I define? I guess it should be:

select stock
set index to stockid

then if I change to MySQL, should I change all the code?

thanks for the help.

regards,

Jerry