Reagrding Multiselect Field Type issue

10 views
Skip to first unread message

Ganesh Yadav

unread,
Nov 29, 2024, 3:57:12 AM11/29/24
to Kaizen
Respected Sir,


image.png
we Choose Multilpe Value and Work Properly but in event trigger we face some issues

so we try to use Multi Select Field Type
we see same value come as AutoFill texbox Multple

Like this values :   Hole Punch,flexo 1 clr,LOW MOQ CHARGES



CREATE PROCEDURE [dbo].[get_AddonPouch]
-- exec get_AddonPouch 'Hole Punch','305','840','',0;
        @PAddonPouch varchar(255),
        @NWidth numeric(18,2),
        @Nlength numeric(18,2),
        @SessionId varchar(255),@UserId int
AS
BEGIN
        SET NOCOUNT ON;
        Declare @TranType varchar(255)

select @TranType=isnull(@PAddonPouch,'0')+','
print @TranType;
select trim(items) as TranTypeID into #TranType from dbo.Split(@TranType,',') where items<>'0'
   
    Declare @AddonPouchMasterId varchar(255),@AddonPouch varchar(255),@AdType varchar(255),@AdValue numeric(18,2),@ValueonPCS numeric(18,2),@ValueonKGS numeric(18,2)
    Declare AddonPuchCursor CURSOR FOR
    Select AddonPouchMasterId ,
           AddonPouch ,
           AdType ,
           AdValue ,
           ValueonPCS ,
           ValueonKGS
    from AddonPouchMaster
    where AddonPouch in (select TranTypeID from #TranType)
    Declare @CalcAddonPCS numeric(18,2)=0,@CalcAddonKGS numeric(18,2)=0;
    OPEN AddonPuchCursor;
   
    FETCH NEXT FROM AddonPuchCursor INTO @AddonPouchMasterId,@AddonPouch,@AdType,@AdValue,@ValueonPCS,@ValueonKGS;
   
   WHILE @@FETCH_STATUS = 0
BEGIN
   
        If @AdType='Direct'
        Begin
           print 'Direct';
           set @CalcAddonPCS=@CalcAddonPCS+@ValueonPCS;
         --  set @CalcAddonKGS=@CalcAddonKGS+@ValueonKGS;


        END
        If @AdType='Width'
        Begin
print 'Width';
            set @NWidth=(@NWidth/10)*1000;
set @CalcAddonPCS= @CalcAddonPCS+(@NWidth*@AdValue);
           -- set @CalcAddonKGS= @CalcAddonKGS+(@NWidth*@AdValue);

        END
        If @AdType='Length'
        Begin
print 'Length';
set @Nlength=(@Nlength/10)*1000;
set @CalcAddonPCS= @CalcAddonPCS+(@Nlength*@AdValue);
           -- set @CalcAddonKGS= @CalcAddonKGS+(@Nlength*@AdValue);

        END


FETCH NEXT FROM AddonPuchCursor INTO @AddonPouchMasterId,@AddonPouch,@AdType,@AdValue,@ValueonPCS,@ValueonKGS;
    END;
    CLOSE AddonPuchCursor;
    DEALLOCATE AddonPuchCursor;
    --select @CalcAddonPCS basicaddonpouchgroundpcs ,@CalcAddonKGS addonpouchgroundkgs;
    select @CalcAddonPCS basicaddonpouchgroundpcs;
   
END


I am use Same Procedure for Multi Select but in  Chrome Console Error Show as Follows:

image.png

Please help on this issue as soon as poosible.




Reply all
Reply to author
Forward
0 new messages