>>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
2nd option doesn't copy properties like sendupdates(), updatenamelist() etc etc
Cetin