Share
ReportI have been running the following script sucessfully in GP 9 but when I run it in GP 10 I get the error Error Executing Script 'After Document' Line 1: Variable uses an Automation type not supported in VBScript
The script I run is
sSQL = "Update Sage_Transactions set Updated " & _
"= 1 where uniquereferencenumber = '" & _
SourceFields("uniquereferencenumber") & "'"
'Create a new connection
Set pConnection = CreateObject("ADODB.Connection")
'Open the connection to the database
Call pConnection.Open("Inform Sage Integration", "sa", "ITdbserver01HO")
'Execute the stored procedure
Call pConnection.Execute(sSQL)
'Close the connection
Call pConnection.Close
sSQL = "Update Sage_Nominals set Updated " & _
"= 1 where uniquereferencenumber = '" & _
SourceFields("uniquereferencenumber") & "'"
'Create a new connection
Set pConnection = CreateObject("ADODB.Connection")
'Open the connection to the database
Call pConnection.Open("Inform Sage Integration", "sa", "ITdbserver01HO")
'Execute the stored procedure
Call pConnection.Execute(sSQL)
'Close the connection
Call pConnection.Close
sSQL = "Update Sage_Tax set Updated " & _
"= 1 where uniquereferencenumber = '" & _
SourceFields("uniquereferencenumber") & "'"
'Create a new connection
Set pConnection = CreateObject("ADODB.Connection")
'Open the connection to the database
Call pConnection.Open("Inform Sage Integration", "sa", "ITdbserver01HO")
'Execute the stored procedure
Call pConnection.Execute(sSQL)
'Close the connection
Call pConnection.Close
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
1