Hi Wayne

Thanks for you help. I will give this a try and trouble you further if I get stuck <g>.

>If it is a character based field, make your view's where using LIKE... then set the parameter to %.


Like you mention it below about searching for a -99999 record everytime then shouldn't the code be like this:

>

>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.

I am using CodeBook, the predecessor of Codemine, I think.