>Using Stonefield Database toolkit I can copy and paste a view from one database into another. Unfortunately a client has 'legacy data' not using Stonefield.
>Is there any way to copy and paste views between databases in regular VFP?
1)
-Do home()+'tools\gendbc\gendbc' and point your source dbc
-This would create a prg version of your database and tables
-Modify comm < saved prg name >
-Open your target DBC
-Locate the function that says 'MakeView(...)' and select code
-Right click and Execeute selection
2)
-Open database
-Modify view
-Right click to view SQL
-Copy SQL
-In command window open target DBC
-Write
create SQl view 'newviewname' as < paste here >
and [enter]
Cetin