I have just recently dealt with data being transported to MySQL from VFP tables.

I have designed a routine that successfully upsizes the VFP tables and their indexes to a MySQL equivalent.

The problem that I am having is that I use a lot seeks in my code to retrieve data to the user at VFP's breakneck speed but MySQL and I am assuming that this applies to all database servers that conform to some SQL standard, the indexes are structured as FIELD1,FIELD2,... whereas VFP indexes are expression based.

VB can successfully use SQL server based indexes as its seek is structured accordingly but what could be used as an equivalent for VFP.

Thanks in advance for any help relating to this situation.