>I have a remote view from Oracle. While running the program using this view, the users will have to filter records based on different search criteria. eg. One time a user can serach by id field, another time by city, another time by city and zip code etc etc. The maximum the users will use for our app is 9. How can I parametrize my view to do all these different criteria searches?. Do I have to recreate my view each time to change the search criteria? If so, if one user searched by one field and another recreates the view woth another search criteria, would'nt the first user see the changed view now??
>I heard I have to SQLEXEC() to take care of this problem, but I don't know how!
>
>Thanks in advance.

Assuming that search criteria might be different and resulting WHERE clause might be complicated, you can better opt for calling stored procedure sending search criteria values as parameters.