Advertisement
Guest User

Untitled

a guest
Jun 20th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. ' ProcessData Function
  2. '
  3. Function Run_VB_Script()
  4.  
  5. Dim oCmpSrv
  6. Dim PLIST
  7. Dim oPickListLines
  8. Dim lRet
  9. Dim lErrCode
  10. Dim sErrMsg
  11. Dim errCode
  12. Dim errDesc
  13. Dim transstate
  14.  
  15. On Error Resume Next
  16.  
  17. Set oCmpSrv = CreateObject("SAPbobsCOM.Company")
  18. oCmpSrv.Server = "SERVER02"
  19. oCmpSrv.CompanyDB = "SBO_IB_LIVE"
  20. oCmpSrv.UserName = "manager"
  21. oCmpSrv.Password = "1234"
  22. oCmpSrv.Language = 3
  23. oCmpSrv.UseTrusted = False
  24. oCmpSrv.DbServerType = 8
  25. oCmpSrv.DbUserName = "sa"
  26. oCmpSrv.DbPassword = "SAPB1Admin"
  27.  
  28. lRet = oCmpSrv.Connect
  29. If lRet <> 0 Then
  30.  
  31. lErrCode = oCmpSrv.GetLastErrorCode
  32. sErrMsg = oCmpSrv.GetLastErrorDescription
  33.  
  34. ThisStep.LogError sErrMsg
  35.  
  36. 'Throw exception
  37. Err.Raise CLng(lErrCode), CStr(sErrMsg)
  38.  
  39. Else
  40. Variables("sboCompany") = oCmpSrv
  41. ThisStep.LogInfo "STEP 0 - DATABASE CONNECTED "
  42. End If
  43.  
  44. Dim Doc
  45. Dim canceldoc 
  46.  
  47.  
  48. Set doc = oCmpSrv.GetBusinessObject(13)
  49. doc.GetByKey(40425)
  50.                    
  51. Set cancelDoc = doc.CreateCancellationDocument()
  52. lret=cancelDoc.Add()
  53.  
  54.  
  55. lErrCode = oCmpSrv.GetLastErrorCode
  56. sErrMsg = oCmpSrv.GetLastErrorDescription
  57.  
  58. ThisStep.LogError sErrMsg
  59. ThisStep.LogInfo lret
  60.  
  61. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement