Hi,
I'm writing a VBScript that checks to see if a global variable is already set. If the variable isn't set then I want to assign an ADODB object to it. If it is set I want to leave it alone.
The issue that I'm having is that the check is always false. I don't know how to clear all the global variables. I've tried stopping and starting the service but that doesn't seem to do it. I have no other actions that use global variables. I'm not sure if it's me, the code, or Kiwi that's the issue here.
Code:
If VarType(Fields.VarGlobal02) <> 9 Then '{Global command - Not assigned yet}
Set thecommand = CreateObject("ADODB.Command")
thecommand.CommandType = cnstCommand
thecommand.CommandText = "LOG_CONNECTION_EVENT"
thecommand.ActiveConnection = connectionString
Set Fields.VarGlobal02 = thecommand
End If
Thanks,
Curt