>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
Hi Monty,
Check SET EXACT & SET ANSI commands. They do effect the comparision.
See help of these commands for detail.
Bye,
- Jayesh