Hi Mo,
Yes.
Assuming that the base tables are available in the target database, use GENDBC to generate code for the SQL and SETPROPs for the View. Then copy that code to another PRG. In the header of that PRG, put OPEN DATABASE whatever and change all XXX!table references to NewDatabase!table. Run the code.
>
>is there a painless way to copy one view from database to other one??
>
>1- from a similar database
>2- from a different database
>
>Thanks
>Mo
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05