@thesunofme
Please attach the project where the problem occurs. Here or in the PM form.
Describe in more detail what site you are talking about and what proxies, mail services, etc. you use to register accounts, this can also be done in the forum PM.
Prepare Data For Execute Query Insert
-
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
