1. 

   spyhunter88, Member

   Hi team,

   I has found an issue about parameter passing if it has unicode character. My code and export:

   -- inProvince is a parameter of this procedure
   SET inProvince = IFNULL(inProvince,'');
   select 'dbr.report','sp_DBR_Sales_Line_Details_v2', 'new_popup', '[Sales]', concat('inProvince="',inProvince,'"');

   select 'dbr.report', 'sp_DBR_Sales_Line_Details_v2', 'new_popup', '[Sales]', 'inProvince="Cần Thơ"';
   
   select 'dbr.subtitle', 'Sales by  >> Province: Cần Thơ';
   
   select 1 as 'Quantity', 111111111 as 'Sales', 111111110 as 'Cost', 1 as 'GP[GP]';

   And now in the Sales Line Details report, I receive Cần Thơ" with double quote follows, if inProvince='others' it works without double quote.

   Thanks,
2. 

   myDBR Team, Key Master

   Hi,
   this has been fixed in the latest build. Thanks for pointing this out.

   It is generally easier to pass the variables in the result set rather than in the constants.

   --
   myDBR Team

Reply

You must log in to post.