>>>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
And all those can be queried and set using dbget/setprop.
Cetin