I would like to know by programm if a view exists before I create it.
Besides, I want to do a form upon a changing parametrized view. The idea is for the "look for button". Each time a user change the criteria fields, I need to create the view.
For example,
1st step
create sql view vistaejemplo as select * from ejemplo
2nd step
create sql view vistaejemplo as select a.* from ejemplo a;
where a.id=m.userid
3nd step
create sql view vistaejemplo as select a.* from ejemplo a;
where a.nombre=m.usernombre and a.apellido=m.userapellido

Other way to do it, is changing the sql property, by it is only read.

Gracias colegas.
Nacho