Passing array as parameter for prepared query ?

Passing array as parameter for prepared query ?

Postby AlexanderPriem » Mon 20 Nov 2006 17:30

Hello,

I have a prepared query like the following :

Select * From TableName Where Field1 In @1;

Now I want to pass an array of integer to the parameter @1, like this :

objCommand.Parameters.Item['@1'].set_Value(arrValues);

But I get an error saying the "Method is not supported".

Is it possible to pass an array of integer as a parameter to a prepared query, and if so, how would I do this ?

Kind regards,
Alexander Priem.
AlexanderPriem
 
Posts: 29
Joined: Fri 24 Feb 2006 09:54

Postby Alexey » Tue 21 Nov 2006 08:07

No, it is not possible to pass an array as a parameter to a statement.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL