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.

Perhaps an array is the wrong data structure to be using. What is your use case? — D'Arcy Rittich, Jan 21 '10 at 20:46
A disconnected recordset might suit: http://stackoverflow.com/questions/268648/how-do-i-sort-arrays-using-vbscript/308735#308735 — Fionnuala, Jan 21 '10 at 21:30

score 2 · Accepted Answer · answered Jan 21 '10 at 20:47

2

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).

answered Jan 21 '10 at 20:47

Dana

32,083
17
62
73

Rats....I come from a DB background and arrays look so much like a db that I was hoping there was something out there. – Keng Jan 21 '10 at 21:12

score 2 · Answer 2 · edited May 23 '17 at 10:27

2

A disconnected recordset might suit: How do I sort arrays using vbscript?

edited May 23 '17 at 10:27

Community

1
1

answered Jan 21 '10 at 22:13

Fionnuala

90,370
7
114
152

Is there a way to query a VB Script Array?

2 Answers2