hi,
I was looking for the answer in the demos or forum, but could not find much.
If i have code like this:
SELECT 'dbr.hidecolumn','ID';
SELECT 'dbr.javascript', "function confirmdel(obj) {return confirm('Delete lead note \\''+$(obj).parent().children().eq(1).text()+'\\'?');}";
SELECT 'dbr.report', 'sp_DBR_LeadNotes_del', '[del]', 'hiddendiv', 'inID=ID', 'event=click', 'callbefore=confirmdel';
SELECT 'dbr.editable', '[Notes]', 'sp_DBR_LeadNotes_edit_note', 'inID=ID','show_link=[NoteType]=="General"','type=autosize';
SELECT 'dbr.no_data', 'No notes exist for the lead'; SELECT 'General' as NoteType, date(TimeCreated) AS Created, ID, LeadID, Notes, LastUpdateUser, TimeModified, 'dbr.purehtml:<div class="i_delete"></div>' as '[del]' FROM LeadNotes WHERE LeadID=inID; SELECT 'dbr.button', 'ADD NEW NOTE';
SELECT 'dbr.report', 'sp_DBR_LeadNote_new', 'newnote[]', 'inLogin=(inLogin)', 'inLeadID=(inID)' ;
SELECT 'dummy result set for the button'; SELECT 'dbr.embed_object', 'hiddendiv';
In my sp_DBR_LeadNote_new prodedure i do simple insert into LeadNotes table.
I would like user to immediately see newly added row in resultset above the button. So I have to add "select dbr.refresh;" inside of sp_DBR_LeadNote_new - however, it refreshes the whole report and i dont want that to occur. I would really like to refresh only result set immediately above the "ADD NEW NOTE" button.
I tried to play with embeds but still no luck.
How can I achieve this?
Thank you!