Did I read somewhere that this can't be used for SELECT commands???
Update - If you can do a SELECT with a RDC ExecuteBatch command does it only return one result or does it execute JobDone for as many times as there are items in the List.
I'm currently doing an ExecuteQuery using WHERE IN and it executes JoibDone for each item in the List
ExecuteBatch is only for "non-queries" statements. You will need to call ExecuteQuery for each query. Note that you can send many queries at the same time.
Thanks Erel
The "IN" isn't working, thought that I had it working but it's not working now
I'm sending many queries but they don't seem to come back in the same order that they are submitted in. I've handled it in my code but am I doing something wrong for them to come back in a random order. When I say they are coming back, it is in JobDone Sub which gets executed for each of the many questions.
The jobs are not expected to return in the same order as they are executed in parallel by the server. You can use the Tag parameter to know which task has returned.