1. 

   ksimkin, Member

   Hi Using the code below the data list displays but no the add Button am i missing some thing?

   CREATE PROCEDURE sp_DBR_PropDisinvestment()
   BEGIN

   select 'dbr.purehtml', '<div class="Centre"></div>';

   select 'dbr.javascript', "function confirmdel(obj){return confirm('Delete Site \\''+$(obj).parent().children().eq(0).text()+'\\' from Disinvestment List ?');}";

   select 'dbr.report', 'sp_DBR_DisUpdate', '[Edit]', 'popup', 'inRecord_id=Record_id','inSite_ID<=Site_ID','inYear_ID<=Year_ID';

   select 'dbr.report', 'sp_DBR_DisinvestDelete', '[Del]', 'scriptdiv[]', 'in_site_id=Site_ID', 'event=click', 'callbefore=confirmdel';

   select distinct 'dbr.title','DISINVESTMENT LIST';
   -- SELECT 'dbr.sum',4;
   select 'dbr.hidecolumn','Disinvestment_ID','Site_ID','Year_ID','Record_id';

   select
   t.id as 'Record_id',
   concat(tbl.SiteCode,' ',tbl.SiteName) as 'Site / Building',
   tb.yearnum as 'Year',
   tbl.GIA as 'GIA (m2)',
   'Edit',
   'Del',
   t.id as 'Disinvestment_ID',
   t.site_id as 'Site_ID',
   t.year_id as 'Year_ID'

   from BCHC_NHS_FACETS.tbldisinvestment t,BCHC_NHS_FACETS.tblcostriskyearcat tb,BCHC_NHS_FACETS.tblSites tbl

   where t.site_id = tbl.id and t.year_id = tb.id ;

   select 'dbr.report', 'sp_DBR_AddDisinvestment';
   select 'dbr.button', 'New Comment';

   END
2. 

   myDBR Team, Key Master

   You are missing a result set for the dbr.button-command. If you do not need to pass any parameters to sp_DBR_AddDisinvestment, just use a dummy result set:

   select 'dbr.report', 'sp_DBR_AddDisinvestment';
   
   select 'dbr.button', 'New Comment';
   
   select 'do it';
   
   

   --
   myDBR Team

Reply

You must log in to post.