On Thursday 18 February 2010 06:09:30 am Mark Stanton wrote: > Ed already wrote a nice class for producing SQL to create MySQL > tables from a VFP database. > > Has anyone got anything similar for views? And how about data? > > All the best > Mark Stanton
Hi Mark, VFP Views are little more than a SQL statement. So the problem is not getting the statement but converting it to the proper syntax of the DB you are using. For example Postgres requires special constraints/triggers (not sure of the name) to allow inserts, updates, Return, etc... So just copying the Views would do very little beyond knowing the field names and possible joins. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
