I have a script that runs fine and loops through the input file just fine, and then connections the the database and then enters data in the GUI. The issue is when it does the 65th loop it stops with the following error:
An exception occurred in the "Functions" unit at line 86
[INTERSOLV][ODBC Paradox drive] Optional Feature Not Implemented
If I remove one of the database checks before the one that fails then the script will do one more and then fail. If I remove five (5) database calls or checks then the script will do five (5) more and then fail. This has to be some limit that I'm hitting and I need to loop though and check the database about 768 times during the script run.
What I tried: I added the driver close command and that did not fix the problem and I'm at a lost what is stopping the scripts from connecting to the database over and over again?