I'm struggling reading data with the async script provided with the snippet in TIA Portal, any hint on how to load data from database to the table?

I'm Using the following script, with the TraceViewer I can see that the value are read from the db, but the table still shown the default values

export async function My_table_CustomWebControl_1_Properties_TableDataString_Trigger(item) {
try{
let value;
let connectionstring = "Driver={ODBC Driver 17 for SQL Server}; Server=10.0.3.127; Database=test; trusted_connection=no; UID=sa; PWD=Htcdiamond_90;";
let conn = await HMIRuntime.Database.CreateConnection(connectionstring);
HMIRuntime.UI.DataSet.Add("DatabaseConnection",conn);
let con = HMIRuntime.UI.DataSet("DatabaseConnection");
let query = "SELECT TOP 1 * FROM test.dbo.PLCDATA_2 order by piantaggio desc;";
let results = await con.Execute(query);
if(results !== undefined && results !== null)
{
let statements = results.Results;
for(let statement in statements)
{
let rows = statements[statement].Rows;
for (let i in rows)
{
let row = rows[i];
for(let key in row)
{
value = row[key];
HMIRuntime.Trace(value);
}
}
}
}
conn.Close();
}
catch(e)
{
let res = e.Results;
for(let statement in res)
{
let errors = res[statement].Errors;
for (let i in errors)
{
let detailed = errors[i];
HMIRuntime.Trace("Errors state : " + detailed.State);
HMIRuntime.Trace("Errors Message : " + detailed.Message);
}
}
}
return value;
}

Instead if I set a sync script, like the following, it works:

export function My_table_CustomWebControl_1_Properties_TableDataString_Trigger(item) {
let value;
value = '[{"x":"1","y":"2"}]';
return value;
}

 Any hint?

Thanks!

------------------------------------------------------------------------------------------
Split from Display DB data into a table.