Good Morning...
I am running into an issue trying to run a table rebuilding script that I wrote, and I'm wondering if it is due to including a script that also includes itself multiple times, depending upon the results generated by the script itself...
That may sound a bit confusing, but here is what it does...
I have a script that I INCLUDE called pos_create which basically uses the available data to create a position in a matrix
The creation of that position may cause another position in the matrix to cycle, which would generate another reentry position, and I basically just add that position id to a DBtable (Stack) for later processing...
The included script continues processing, doing multiple processes until complete...
Then, at the end of the included script, I check query the (Stack) table for any unprocessed records, and if there are any, I assign the necessary variables and INCLUDE the same script that is currently running again to go through the same process...
Trying to rebuild multiple tables from a single Transaction table that has 3700 +- transactions in it. The script works fine through about 1200 then stops, and when I try to rerun it from that point, it gets 20 +- more and stops again... then after doing this 3-4 times it gets 1-2 records processed on each restart.
Can someone explain why this would be? It is taxing local resources? Is there just an inherent problem with including a script from itself? I'm perplexed, and this has been driving me nuts for a few days now.
thanks in advance for any enlightenment you may have to offer.
Douglas