Using MM, I have developed an application that utilizes both VFP (local) and SQL Server (remote) tables. Now I want to add Oracle and I am not sure what is the best way to handle the remote views. Should I:
A. Have 2 .dbc’s where the rv’s in one are for SQL and the other for Oracle
B. lv’s for Local, rv’s for remote (SQL) and create ov’s for Oracle and add code to the business objects to handle a third set of views
C. other ideas?
I have also had requests for DB2, so there may be a 4th set of views in the future.
Kind Regards,
Mat