create Procedure spICB_CustomerIntegration as Begin Set nocount on --exec spICB_CustomerIntegration --select * from rm00101 where custnmbr='DJDJDJD' declare @O_iErrorState int, @oErrString varchar(255), @errordesc nvarchar(100) select @O_iErrorState = 0 if (@O_iErrorState = 0) begin exec taupdatecreatecustomerrcd @I_vCustnmbr='DJDJDJD', @I_vCustname='Devin Johnson3', @I_vADRSCODE='PRIMARY', @O_iErrorState = @O_ierrorstate output, @oErrString = @oErrString output end IF @O_iErrorState <> 0 Begin Set @errorDesc = (select errordesc from dynamics.dbo.taerrorcode where errorcode = @O_iErrorState) select @oErrString select @errorDesc End end |
Dynamics GP >