>>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