Is there a way to query a VB Script Array?

Question

I'd like to be able to query an array (multi and single dimensional ) with something like SQL. Is there a way to do this?

It just seems extraordinarily wasteful to step through it one record at a time.

Answer 1

Nope. Do you wasteful in terms of having to write the loop, or performance wise? I'd expect heaping a layer of abstraction over the array would hinder performance.

If you need to search your arrays in something other than linear time (ie., one at a time), you'll need to organize them so that you can so a binary search over them (or any number of other algorithms).

Answer 2

A disconnected recordset might suit: http://stackoverflow.com/questions/268648/how-do-i-sort-arrays-using-vbscript/308735#308735