Please help

(3 posts) (2 voices)
  • Started 1 year ago by ajitdixit
  • Latest reply from myDBR Team

Tags:

No tags yet.

  1. ajitdixit, Member

    I have SP as under ;
    if object_id('DIXIT_DBR_UPDATE_additionalremark_DIXIT','P') is not null
    drop procedure DIXIT_DBR_UPDATE_additionalremark_DIXIT
    go
    CREATE PROCEDURE [dbo].[DIXIT_DBR_UPDATE_additionalremark_DIXIT](
    @ACRPID bigint ,
    @ATYPE char(10),
    @additionalremark varchar(300),
    @inLogin varchar(30)
    )
    AS
    BEGIN
    UPDATE Tests_MIS SET additionalremark = @additionalremark, LastUpdatedAt= getDate() , LastUpdatedBy=@inLogin
    WHERE ACRPID = @ACRPID
    AND ATYPE = @ATYPE
    END
    go

    I call as under ;

    select 'dbr.editable', 'additionalremark', 'DIXIT_DBR_UPDATE_additionalremark_DIXIT' ,'ACRPID=ACRPID','ATYPE=ATYPE','additionalremark=additionalremark','type=textarea'

    It is not updating as expected
    How do I solve this ?

    Posted 1 year ago #
  2. ajitdixit, Member

    How number of parameter passed are evaluated in case of 'dbr.editable'

    Posted 1 year ago #
  3. myDBR Team, Key Master

    Hi,
    in the dbr.editable, the editable value is passed in as the last parameter so you might want to move the @additionalremark to be the last parameter. Also, 'autosize' is usually more user friendly than the 'textarea' unless you want a specific number of rows.

    --
    myDBR Team

    Posted 1 year ago #

Reply

You must log in to post.