Share
ReportDeclare @NxtIVADJ char(17)
Declare @NewIVADJ char(17)
Declare @CCDocDate date
Declare @CCBatchNum char(15)
Declare @NextIVADJLEN int
select @NxtIVADJ = NXADJDOC from IV40100 with (nolock)
set @CCDocDate = CONVERT(DATE, (GETDATE()))
set @CCBatchNum = 'CYCLE COUNT'
set @NextIVADJLEN = LEN(rtrim(@NxtIVADJ))
set @NewIVADJ = (LEFT(rtrim(@NxtIVADJ), @NextIVADJLEN-5) + convert(char(5), Convert(int ,Right(rtrim(@NxtIVADJ),5))+1))
Select @NxtIVADJ as NxtIVADJ, @CCDocDate as CCDocDate, @CCBatchNum as CCBatchNum, @NextIVADJLEN as NextLength, @NewIVADJ
BEGIN TRY
UPDATE IV40100 Set NXADJDOC = @NewIVADJ;
END TRY
BEGIN CATCH
--some log posts will go here
END CATCH;
Is it safe to write directly to this Table-Field? Is there a built in function or procedure that will update(increment) this for me?
*This post is locked for comments
All responses (
Answers (
18,267
