How to delete Caché global by its value in Caché ObjectScript?
Good day, I have this issue. I have global like: ^myglobal(varX) = $LB(var1,var2). I need to delete all globals that have variable var1 in that list same without a need to iterate through all globals and checking their value.
- in database exist following:
^myglobal("Marek") = $LB("code2",1400)
^myglobal("Ondrej") = $LB("code1",12)
^myglobal("Nikita") = $LB("code2",32)
^myglobal("Evgeny") = $LB("code1",76)
^myglobal("Maks") = $LB("code2",99)
^myglobal("Eduard") = $LB("code1",14)
Now! How to delete all globals that have in list in the first place value "code2" please? It doesn't have to be LIST, it can be any other simple value.
But this question can be put in other way like this:
How to prevent to not set new globals with same value? In other words, when I am creating new global I want to guarantee that its value is UNIQUE in order to other globals.
Thank you in advance for your answers.