>>I'm creating a remote view and would like this view to be parameterized on more than on field.
>>
>>Exemple
>>
>>Select * from mytable where anyfield = anyvalues
>>
>>i replaced anyvalue with ?Cvalue.
>>
>>I tried to replace anyfield with this ?Canyfield
>>
>>?Canyfield = Mytable.field
>>
>>This is not working, is that possible ?
>>
>>
>>Thanks
>
>Hi,
>
> You can try to check in the microsoft knowledge bas but the parametrized view are very restricted. You can do only parametrized view like :
> SELECT * FROM myTable WHERE myfield1 = ?cValue
>OR
> SELECT * FROM myTable WHERE &cCondWhere
>
>Note: The last statement cannot work on remote views. Only the first one actually does work!
>
>Hope this help...


Thanks