1. 

   Nithin, Member

   Hi,

   I have an editable(linked) report. I would like to provide a button to add new row into that report. I have written the below code which is working. However, I see a warning above my button which reads as "Unknown column reference: Name". Can someone explain the mistake I'm doing here.

   DROP PROCEDURE IF EXISTS sp_DBR_manageAccntMgrs
   $$
   CREATE PROCEDURE sp_DBR_manageAccntMgrs()
   BEGIN

   select 'dbr.report', 'sp_DBR_editManagers', 'Name', 'popup', 'inName<=Name', 'inContact<=Contact';

   select managerName Name, contact Contact
   from mobclicks.mobc_account_manager;

   select 'dbr.report', 'sp_DBR_addManager', 'Name', 'popup', 'inName<=Name', 'inContact<=Contact';
   select 'dbr.button', 'Add Manager';
   select @Name;

   END
   $$
2. 

   myDBR Team, Key Master

   select 'dbr.report', 'sp_DBR_addManager', 'Name', 'popup', 'inName<=Name', 'inContact<=Contact';
   select 'dbr.button', 'Add Manager';
   select @Name;
   

   To refer to column Name in your result set, you should have
   

   select @Name as 'Name'

   Additionally, you do not have column name Contact in the result set so you cannot use 'inContact<=Contact'. If you leave it out, myDBR will automatically ask value for the contact.

   --
   myDBR Team
3. 

   Nithin, Member

   Thanks a lot keymaster...that really helped.

Reply

You must log in to post.