>Hi Mo,
>
>I assume it to be local views. Extract the syntax of the sql statemnet and create the view in your new db.
>Pay attention to the table names referred in the sql statement, they must point to a valid tablename wich might be not in your newdb.
>
>Play around with something like this (just hacked and not tested):
>
>viewsql=dbgetprop("myview","view","SQL") &&extract sql view syntax
>command="create sql view newview as "+viewsql &&create command to create view
>set database to mynewdb && set target db
>&command && create view
>
>
>regards
>Giesbert

Thanks all

Basicly, I extracted the SQL code from the view then in program I ran the
create sql view, making sure that the database is set to target one.

it worked

Thanks
Mo