On Thursday 07 November 2002 04:51 pm, Dan Neuman wrote:

> I have a question for the SQL Server remote view gurus.

Only if someone tells me why my combobox isn't working <g>...

> I need to create a remote view to a SQL database, and in the where clau=

se

> I would like to provide a list of values. And if the field matches one

> of those values, then return the record.

>

>

> Is there a way to do that?

>

>

> Something like:

> Local vp_List

> vp_List =3D ["A","B","C"]

> Use RemoteViewName

>

>

>

> Remote View SQL Statement:

> Select Table.* from dbo.Tablename where inlist(Tablename.Field, ?vp_Lis=

t)

try this (works with spt, not sure about remote views):

private vp_List

vp_list =3D [("A","B","C")]

* remote view:

select table.* from dbo.tablename where tablename.field in ?vp_list

--=20

Paul McNett - p@ulmcnett.com

Hollister, California, USA