aXes User Forum

Posted: **22 Dec 2021, 08:29**

Hi

If you have a simple table, with information like this:

ID          DESCRIP           
A1          Niño              
A2          María             
A3          Canción           
A4          Mamá              
A5          Euro Code is €

and you use aXes to runqry *n that table you get this:

: dd01.jpg (63.74 KiB) Viewed 8047 times

which shows the data correctly (well, kind off, I missed the euro money character),
but if I use the same table in a dynamic dropdown, and create the dynamic table like this:

Code: Select all

-- ====================================================================================
-- Test Drop Down
-- ====================================================================================
    DefineObjectInstance { 
      className          = "DynamicTable", 
      name               = "TestDD",   
      source             = "sql", 
      selectSQLcommand   = "ID,DESCRIP from QGPL.TESTDD", 
      resultColumnNames  = { "value", "text" }, 
    };

I get this in the dropdown:

: dd03.jpg (76.47 KiB) Viewed 8047 times

Is there any way to keep the accent characters in the dropdown? if not, any way to replace those? I tried using REPLACE in the SQL instruction, but seems that the data already arrives with garbage characters instead of the correct ones...

Happy holidays!

Posted: **28 Dec 2021, 09:35**

Just sharing the solution here:
https://axesdocs.lansa.com.au/index.php ... -documents

Code: Select all

DefineObjectInstance {
      className          = "StaticTable",
      name               = "TEST03",  
      source             = "sql",
      selectSQLcommand   = "EMPNO, CAST(EMNAM AS CHAR(14) CCSID 65535), CAST(EMADR AS CHAR(62) CCSID 65535) from QGPL.PBEMPF",
      resultColumnNames  = { "value", "text", "address" },
      resultColumnCCSID  = { text=937, address=937 };
   };

just to use 284 instead of 937 and dynamic table instead of static.

Posted: **17 Jun 2022, 01:35**

just adding an extra note here, when accessing some sample tables in LANSA with nvarchar fields, using value 1140 for the CCSID does the trick.

aXes User Forum

Accents and Letters with Character Codes, sql, dropdown

Accents and Letters with Character Codes, sql, dropdown

Re: Accents and Letters with Character Codes, sql, dropdown

Re: Accents and Letters with Character Codes, sql, dropdown