Prepare Data For Execute Query Insert



  • i manage to debug the error on my part

    The problem is the following:
    Screenshot 2022-01-14 170457.jpg
    Screenshot 2022-01-14 170733.jpg

    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


Log in to reply
 

  • 5
  • 3
  • 5
  • 7
  • 2
  • 3
  • 2
  • 2