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?
01, 02, Demed
01, Demed
etc..
But how do I use the Array in the Query?
|
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? |