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
For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life. John 3:16
