Check
gentable.prg, genview.prg File #
9388>I have two databases that are very similar. I have views in one that need to be in the other. I get the sql to create them using dbgetprop... and i'm able to create the view in the 2nd database... how do I programatically get a view from 1 dbc to another...with all the same properties....
>
>for example....
>
>set database to data1
>mysql = dbgetprop('v_location',"view","sql")
>
>set database to data2
>CREATE SQL VIEW 'v_location' AS &mysql && create view in database 2
--sb--