Run report-button causes loop

(4 posts) (2 voices)
  • Started 6 years ago by shhedrick
  • Latest reply from shhedrick

Tags:

No tags yet.

  1. shhedrick, Member

    After installing 3.2 and also with 3.3, text in the "Run report-button" fields causes a loop. The report being invoked is a report that does an update and has a parameter defined as a popup. The dialog box for the popup appears for a fraction of a second and then the screen goes blank. An update log shows that the update routine has been invoked many times before I close that tab.

    Removing the text from the "Run report-button" field causes the report to work normally.

    invoking line from calling report:
    select 'dbr.report', 'sp_DBR_TDProduct_Update', 8, 'popup', 'tdID=17', 'newData<=8';

    update routine:
    DROP PROCEDURE IF EXISTS sp_DBR_TDProduct_Update
    $$
    CREATE PROCEDURE sp_DBR_TDProduct_Update(tdID bigint, newData varchar(50))
    BEGIN

    update xhrBlossburg.hrTransactionDetail
    set PRODUCT = newData
    , name = 'Office'
    where id = tdID;

    call hrManagement.pAppLog ('hrTransactionDetail',tdID,'Update',CONCAT_WS(' | ','Product',newData));

    select 'dbr.refresh', 0;

    end
    $$

    If you need a print of the "Edit Report" page, let me know.

    Posted 6 years ago #
  2. myDBR Team, Key Master

    We'll take a look at it.

    Thanks for reporting the issue.

    --
    myDBR Team

    Posted 6 years ago #
  3. myDBR Team, Key Master

    This has beed fixed. Run the updater to get the latest build.

    Again, thanks for reporting the issue.
    --
    myDBR Team

    Posted 6 years ago #
  4. shhedrick, Member

    Works.

    Thanks!

    Posted 6 years ago #

Reply

You must log in to post.