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 ?
2. 

   ajitdixit, Member

   How number of parameter passed are evaluated in case of 'dbr.editable'
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

Reply

You must log in to post.