Prepare Data For Execute Query Insert

[manuelacosta98]

i manage to debug the error on my part

The problem is the following:

When i try to create and update query, with the execute query method nothing is working in it always add unnecessary characters to the variables i don't know why, i try the following:

INSERT INTO output (
id_origin,
marca,
anio,
tipo,
version,
edad,
cp,
general_de_seguros,
qualitas,
"qualitas+",
crabi,
"crabi+",
aba,
"aba+",
mafre,
"mafre+",
gnp,
"gnp+",
el_potosi,
"el_potosi+",
hdi,
wibe,
"wibe+") VALUES (
[[ID]],
[[MARCA]],
[[ANIO]],
[[TIPO]],
[[VERSION]],
[[EDAD]],
[[CP]],
[[GDSCONFORTAMPLIA_0]],
[[QUALITASAMPLIA7Y10_0]],
[[QUALITASAMPLIA5Y10_0]],
[[CRABIWIDE_0]],
[[CRABIWIDE2_0]],
[[ABAWIDE2_0]],
[[ABAWIDE_0]],
[[MAPFREDIRECTOWIDE_0]],
[[MAPFREDIRECTOWIDE2_0]],
[[GNPWIDE_0]],
[[GNPWIDEPLUS_0]],
[[ELPOTOSIWIDE2_0]],
[[ELPOTOSIWIDE_0]],
[[HDIDIRECTOWIDE_0]],
[[WIBEWIDEDOS_0]],
[[WIBEWIDE_0]]
);

Passing the list works in record mode but not in run mode, meaby a bug when dealing with strings?

I try this and passing a list and the values separately and nothing works in run mode, any leads on how to prepare data for the sql insert? Thanks a lot.

BAS Version 24.5.1
Chrome Version 96.0.4664.110
OS Windows 10 PRO version 10.0.18363 BUILD 18363