Hello,

Our VFP6 application should be able to create SQL7 tables and remote views on-the-fly at run-time.

We use xCASE 5 as a database design and management tool.

I am looking for a product or just a VFP code that could create SQL7 tables from xCASE models at application run-time. We cannot use built-in scripting functionality from xCASE because the database structure could be changed by the user at run-time.

I just started to work on a class that is based on DBCX2 and would provide synchronization between xCASE model, VFP DBC, and SQL7 database. It seems like a big task, however. So, I am wondering if somebody has this already done or working on something that is similar to this.

Any ideas would be appreciated.