>Is there any way to copy views? I've got a number of views I need to create for my database that only have minor differences so I'd love it if I could copy the first one and make the modifications to the subsequent ones.
>
>Since they aren't individual files, i.e. contained with a database, I'm not sure how or if I could do this.
>
>Thanks!
>Mandy
DBGETPROP(
,"VIEW","SQL")
will fetch the sql and I have used this at times to modify a query and updated the dbc with
DBSETPROP(.....) I would have to look up syntax. I guess you could get the sql modify it, create a new view with the consistent items such as table,field etc, stuff in the modified SQL. I have no idea what the visual designer would think of this. The designer doesn't mind my modification so it should work. If so you could write a 'wizard' to allow you to modify the query and replicate the common view properties. Good luck!
HTH
Gary
Helping Make Ideas Reality