>When using parameterised, updateable views, I want more freedom on the selection of the records : can a view dynamically be changed (it's WHERE cluase )?
>
>Example : I want the same view based on a product file, a first time for all the products of within a price range FROM,TO (where price between X to Y), and another time the products of wich the price is X, Y or Z (where price in X, Y, Z).
>
>I don't want 2 different views because these examples aren't the only possibilities and the view is the record source of a form ...
Pascal, price IN (x,y,z) will not work in the view.
Since you want an updateable view, will the solution with recreating this view every time according the current parameters in a local temporary database work for you?
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison