I work in converting a long application with various separated modules to SQL server 7. But I want to run it with VFP tables too if the customer don't have SQL.

I have my function S_USE() for open a table with an index and optional alias in normal VFP.

I want to change this function with a new that open a remote view. I tested many times doing this with view designer but it's bad.

I now make a funtion that pass the SQL as first parameter and inside I make a SQLExec and convert to view. I have a data dictionary and i use it for helping me with this.

My question is: Is this way good? My system has many tables. More than 200, and many modules that works on this. Some recommendation or a place to read about this?