I'm trying to create an editable report. Currently, I'm trying to use the documentation for the "new item" in the database, but the button doesn't even seem to be showing up.
My code in the main report is below:
select 'dbr.button', 'Add Email';
select 'dbr.report', 'sp_DBR_email_new','newEmail[]';
select 'dummy result set for the button';
select * from blah.emaillist;
My code for the sp_DBR_email_new procedure is below:
DROP PROCEDURE IF EXISTS sp_DBR_email_new
$$
CREATE PROCEDURE `sp_DBR_email_new`(inName CHAR(50),
inEmail CHAR(50),
inToDb tinyint(1),
inReplyTo tinyint(1),
inTextAlert VARCHAR(45)
)
BEGIN
insert into blah.emaillist ( Name, Email, ReplyTo, TextAlert) values ( inName, inEmail, inReplyTo, inTextAlert);
select 'dbr.refresh';
END $$
