>where (sometable.isomefield = ?piViewparameter or -99999 = sometable.isomefield)
>
rather than>select *; >from sometable; >where (-99999 = sometable.isomefield or sometable.isomefield = ?piViewparameter) >>We are using the Codemine framework, and have added a lot to it to handle the setting of the values of the fields when we open the cursors. If you are not using a framework, you will need to go through your parameters and set them to wildcard values before opening or requerying your view.