Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Following the reload of data, be it in normal or debug mode, following the completion of the script I am experiencing a big jump in RAM usage and the program crashes.
I am getting the same behaviour whether it be 1 or 1,000,000 lines. What happens at the end of the script that could be causing this?
The log file is showing that the script finished with no errors, so that is not helping me at all.
Thanks for your assistance.
Lee
Actually I found it was due to a count distinct calculation on a table box caption title.
Weirdly, it seems to be calculated even when the whole table box is hidden and the user is navigating in other tabs.. When activating and showing the table, we can see that the title immediately displays the already calculated value when the table box itself is still being calculated. Removing it solved the strange behaviour of the application.
Regards,
Ana
Try putting a Sleep(9000) after the Store.