AnsweredAssumed Answered

Global Variable Conflict in script

Question asked by erob on Nov 4, 2010
Latest reply on Nov 4, 2010 by philmodjunk


Global Variable Conflict in script


Hey guys,

I have a complicated script which has several steps. It involves importing data from an excel sheet to a table and then distributing that data into 2 other tables within the database.

To achieve this I use global variables to carry over the data from script to script. It all works fine.

Except for some reason, if I try and run the script twice in a row, the second time the script gets stuck half-way. However if I close the file, reopen and try then, it works fine. So i'm guessing there's a conflict of some kind with the global variables.

Is there a way I can reset all variables once the script has run? As if I had closed the file and started from scratch?

Any and all info would greatly appreciated.

Thanks guys,