Hi Zak, the current version of SQL Server 7.0 does not have array data type
and also the database API does not allow array exhange.

	Regards.

-----Original Message-----
From: Katsumi Ohsawa [mailto:kosawa@p...]
Sent: Monday, September 04, 2000 4:40 PM
To: professional vb
Subject: [pro_vb] RE: IN list as a input parameter in a stored procedure


Hi,
Before you try to pass an array from VB to it, please check the database
has
an array data type or not?
I think that using a recordset or a result set instead of an array .
Katsumi Ohsawa


-----Original Message-----
From: zak Belghali [mailto:zbelghali@h...]
Sent: Saturday, September 02, 2000 6:44 AM
To: professional vb
Subject: [pro_vb] IN list as a input parameter in a stored procedure


Hi,

I am trying to pass an array or a list of integerd as an input parameter
to
a stored procedure like in an sql statement:

select * from tbl where id IN (1,2,3)

The trick here is the dimension of the array or the list of integers is
unknown.

Thanks in advance.