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