Ah, no. You can't pass an array to an IN clause--especially not with a JET database. You can't really pass an array to any procedure in JET or SQL Server. There is no corresponding type that's an array. There are ways to address the "IN" clause issue but they require creating an ad hoc query on the fly and populating it with the arguments. This is dangerous as it can lead to SQL injection attacks. In SQL Server you can pass a delimited string and parse it with a function (returning a Table) and use that with an IN clause, but this is not an option with JET.
I suggest asking technical questions on the Microsoft newsgroups. You'll get better response time...
I suggest asking technical questions on the Microsoft newsgroups. You'll get better response time...
Leave a comment