The (-99999 = sometable.isomefield) needs to be on the left side - so if it is true, the right is not evaluated.

Ask away... it's no trouble - that's what we are all here for.


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