I don't have experience with a remote view yet; but I suppose you can do it similar to a local view: either with the view builder, or programmatically. I suppose that programmatically, you can provide the complete SQL string.

On the other hand, if you need the data for a report, i.e. read-only, perhaps a query would be more appropriate. I am not sure exactly how this is done with a remote server; perhaps with SQL pass-through?

>Hi Himlar
>
>Had just got to this one, but unfortunately it doesn't completely resolve my problem, which is that I want to do create a view to do this with dynamic user defined data (ie. the decide what is in the list.
>
>This would normally be fine using macro substitution but I need to do this with a remote view and this is not permitted.
>
>Any ideas how I can get around this?
>
>Regards
>Geoff
>
>>inlist() is quite a bit shorter, and should be optimizable:
>>
>>

>>... where inlist(Status, "A", "F", "T", "H", "E", "W")
>>
>>>Hi
>>>
>>>I have a large table with a status field and I want to select the records for a group os status's.
>>>the table is indexed on the status
>>>
>>>this can be done by
>>><pre>lcStatusList = 'AFTHEW'
>>>SELECT* ;
>>>FROM mytable ;
>>>WHERE mytable.status $ ?lcStatusList

>>>
>>>Unfortunately, this does not optimize.
>>>
>>>Is there any way to fully optimize this query without expanding the Select to something like
>>>
>>>

SELECT* ;
>>>FROM mytable ;
>>>WHERE mytable.status = 'A' OR ;
>>>	mytable.status = 'F' OR ;
>>>	mytable.status = 'T' OR ;
>>>	mytable.status = 'H' OR ;
>>>	mytable.status = 'E' OR ;
>>>	mytable.status = 'W'

>>>
>>>regards
>>>Geoff Scott