>Hi,
>I have a view of client table (client_v) which have following FILTER
>
>
>SELECT Client.customerid, Client.ecompnam FROM ;
> kamyip!client;
> WHERE Client.salesmanid = ( ?psalesmanid );
> AND Client.bussid = ( ?pbussid )
>
>
>Now I want to change the Filter of the client_v at runtime by adding
>one more parameters to the query, how can I change it by coding ?
>
>Please advise.
>Thanks.
>Derek Yim
If the first condition produces a result set that is small enough, you can simply apply a SET FILTER to the view.
While you can define a view programmatically, it is somewhat complicated; I never did that.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)