bluebunny72 icon

Form Script to retrieve return value from SP!

bluebunny72 | PRO | 01/11/17 03:59:35 PM UTC | 0 ⭐ | 453 👁️ | Never ⏰ | []
VB.NET |

1.18 KB

|

None

|

0 👍

/

0 👎

ALTER PROCEDURE [dbo].[ILC_GetJobOrderCustomerOrderSp] 
      @JoNum            JobType
     ,@JoSuffix         SuffixType
     ,@CoNum            CoNumType = NULL OUTPUT
     ,@CoLine           CoLineType = NULL OUTPUT
     ,@CoRelease        CoReleaseType = NULL OUTPUT
     ,@CoWhse           WhseType = NULL OUTPUT
AS ...
 
 
 
                Dim invokeResponse As InvokeResponseData
 
                job = ThisForm.PrimaryIDOCollection.CurrentItem("Job").GetValue(Of String)()
                suffix = ThisForm.PrimaryIDOCollection.CurrentItem("Suffix").GetValue(Of Integer)()
 
                ' call ido method...
                'invokeResponse = Me.IDOClient.Invoke("ILC_SLCos", "ILC_GetJobOrderCustomerOrderSp", New Object() {job, suffix, Nothing, Nothing, Nothing, Nothing})
 
                ' use SP! instead...
                invokeResponse = Me.IDOClient.Invoke("SP!", "ILC_GetJobOrderCustomerOrderSp", New Object() {job, suffix, Nothing, Nothing, Nothing, Nothing})
 
                co = invokeResponse.Parameters(2).Value
                coLine = invokeResponse.Parameters(3).GetValue(Of Integer)()
                coRelease = invokeResponse.Parameters(4).GetValue(Of Integer)()
                coWhse = invokeResponse.Parameters(5).Value

Comments