How (if possible) do I translate an algoritm that uses two while-loops that grow exponential to an algoritm that grows in one dimension instead?
while not tableOne.EOF
while not tableTwo.EOF
In this example I need to find every elements in tableTwo with a special status and sum them.
They are then related to tableOne an displayed as this
. .. .
. .. .
and so on.
My only solution to this is to store the value (inside the pharanteses) in the database whenever any status changes inside the program and not use this algoritm.
But I'm just quoirios if it's possible to do some otherway without storing the value before I want it, and instead calculate it dynamically.