VBA how to kill a long loop, each with DB error

[ngong]

Again, trying to conquer SQL from VBscript I got an annoying problem:

When I have an error in a script using SQL such as

function getElementsWithMultipleTags()
   set getElementsWithMultipleTags = Repository.GetElementSet( _
      "select * from t_taggedvalue" _
   ,2)
end function

sub main
   dim objects
   Repository.EnsureOutputVisible "Script"
   Repository.ClearOutput "Script"
   set objects = getElementsWithMultipleTags()
   Session.Output "count of elements " & objects.count
end sub

I get the error message DOA.Fields [0x00000cc1] Item not found in this collection in a loop, too many times.
I found no method to stop the execution of the VBscript program (other than killing the EA task).

Is there one, a bit more smooth?

BTW: why is this script wrong? It works with t_object, but not for t_taggedvalue . EASchema_1558.sql shows both tables to be existant.

[qwerty]

GetElementSet wants the element id (aka t_object.object_id) in the first column. t_taggedvalues doesn't have that.

Maybe you want to

Code: [Select]

select object_id from t_objectpropertiesJust guessing...

q.

[ngong]

Ok, thank you qwerty - now I understand GetElementSet a bit better.
I was looking for a routine given me arbitray result of an SQL query.
However, my routine is working now.

[Geert Bellekens]

for arbitrairy query results use Repository.SQLQuery

Geert

[ngong]

ok - thanks
BTW - do you have an answer for my first question: "how to kill an endless loop?"

[Geert Bellekens]

ok - thanks
BTW - do you have an answer for my first question: "how to kill an endless loop?"

Task manager and kill EA.exe

Geert

[qwerty]

As Geert suggested. It might sound like a harsh solution but EA is not doing anything except interpreting your VBA code. So unless you are doing crucial updates which are not transactionally secured you can kill EA any time. It does not start an independent thread for its VBA interpreter. So no way around that.

q.

[Eve]

Rather than kill EA, kill SScripter.exe.

[qwerty]

Oh, so there IS a thread. I was not aware of that, but mainly because I use only external scripting. Proves that my assumptions are not always right.

q.