>We are trying to SQLize a DBF system, but not migrate it so what we want is a bilingual systems that can work on SQL as well as on DBF base as a brainstorm I think that I can pull this off by moving the BDF to a DBC creating views for them and changing the code to accommodate for the change from DBF to views. Keeping in mind that at logon we will select the default DBC witch might be the DBF base with local views or the SQL base with remote views, am I over thinking this? Are there more practical approaches to this dilemma?That's an older way that works since VFP 6 (or maybe even VFP3, don't remember).
The same local views (same structure) are replicate din anikther DBC with remote views. Just switch and the program showld not notice the difference. Another, more modern way is using a Cursor Adapter where you change a property to change the connection to local (native) or SQL Server through ODBC or OleDB.
HTH