>>Hi,
>>
>>How to copy views from one database to another ?
>>
>>Please advise.
>>
>>Derek
>

>Open database myDBC1
>lcSQL = dbGetProp('myView',"VIEW","SQL")
>open database myDBC2
>create sql view myView as &lcSQL
>

>Cetin

Hi,

That would copy the SQL command - but won't a lot of the other view related information (key fields etc) be missing from the new view?

Regards,
Viv