View Full Version : Query by an Array


Djblois
06-30-2009, 12:23 PM
I want to use code to set an Array like this:

01, 02, Demed

01, Demed

etc..

But how do I use the Array in the Query?

ajetrumpet
06-30-2009, 12:36 PM
this is not clear at all....

Djblois
06-30-2009, 12:43 PM
I want to use an Array in the Criteria Section of a Query. So I can use code to change the Array and the query will update accordingly. The field that I want to filter is Warehouse. So I want to filter by one or more warehouses using an Array.

SOS
06-30-2009, 02:50 PM
I want to use an Array in the Criteria Section of a Query. So I can use code to change the Array and the query will update accordingly. The field that I want to filter is Warehouse. So I want to filter by one or more warehouses using an Array.


I think our terminology is a bit off here. An Array is a collection of data loaded into memory. You are not going to be able to use an "Array" as defined in your criteria. You can build a string which can be used as criteria.

How are you selecting that which you want?