Hi, I would like to use recursive calls too, to be able use a hierarchy table with this kind of structure : hierarchy_table(id_parent number, id_child number) like the nodes of a tree... I've been looking several ways with the loop component, but i did not find any solution. I'm not asking you to do my job, but do you have any idea of how to make easy and not so heavy for the memory, or do i have to use job calls like you explained before? Just for information, i'm using TOS 3.0.5 with Java and a MySQL 5 db, Thanks and have a nice day...
Hi, first: did anyone tried Menuet solution? I think this is not possible because different variables are defined as static. This will lead in many problems. This is, from my point of views, a big design issue. So you need to transform your recursive call to an loop. This should (theoretical) always be possible. If you give some more information about your job, we could try to help you out Bye Volker
Sorry I forgot to give you some feedback. Here it is : I tried emenuet's solution but it did not work (can't remember the error but when I cliked on the run button I got an error message before the process really started). Anyway you were right, it was possible to avoid this recursive call with a loop and a global variable. Thanks Fred
I think the answer to this question is to use tLoop. tLoop(Iterate)->tRunJob(OnSubJobOK)->SubJob Where SubJob is your logic to determine if the loop should end. And maybe adding a Thread.sleep() before the next iteration of the loop may be useful. This is iteration not recursion.