I just created a two field nonupdatable table & its corresponding remote view. Here is the detail of remote view.

Maxrecords=-1
Sourcetype=2
Parameterlist VP_ID,'I',VP_NAME,'C'
SELECT * FROM table Table1 WHERE Table1.ID=?vp_id and Table1.name=?vp_name

I donot get a result set if I leave both the values blank


Prabhjeet Singh Monty
India