Dynamics Community Forum Thread Details

Integration Manager VB Script

I 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") & "'"

sSQL = "Update Sage_Tax set Updated " & _
"= 1 where uniquereferencenumber = '" & _
SourceFields("uniquereferencenumber") & "'"

Quick Links

Leaderboard