Yes, this was just an example, my question is more like: do i have to create a new remote view everytime i need a different WHERE clause.

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