AnsweredAssumed Answered

Global Variable Conflict in script

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

Title

Global Variable Conflict in script

Post

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,

Rob

Outcomes