Stephane,
Why not use the "IN ?SomeVariableList" version but just have one item in the list if you want the field to = a certain value?
Or am I missing something obvious you want to do?
HTH
Barbara
>Hi, We are starting converting our app. which is presently using Native VFP Database TO C/S. and i am pretty new at using views. So my question will probably be an easy one for all of you...
>
>For example, i need to get an updatable view with 2 different parameters of the same table, my select statement in the create sql view would look like this:
>
>1. SELECT SomeFields FROM RemoteTable WHERE MyField = ?SomeVariable
>2. SELECT SomeFields FROM RemoteTable WHERE MyField IN ?SomeVariableList
>
>The only difference is the WHERE clause. Do i have to create 2 different views or is there a better way to to this? Basicly, what i need to know is: do i have to create a new view every time my WHERE clause changes?
>
>Thanks a lot.