I have SP that like as below and it has the update statement at the beginning of SP. I can’t add it into DA tables that return the error. I need to add to DA Command. How to get the result from DA Command?
select @ReturnPrefix + right(replicate(‘0’,4) + cast(@MaxNbr as varchar(4)),4) as FrmNbr
My Coding as below.
lp := aParam.Add; lp.Name := ‘Company’;lp.Value := ‘YY’;
lp := aParam.Add; lp.Name := ‘TxnType’;lp.Value := ‘PTAR’;
lp := aParam.Add; lp.Name := ‘IncNbr’;lp.Value := edt_IncNbr.Value;