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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only