Beas Script Error for SQL

Michelle Campbell

I'm trying to write a simple beas script, but I'm getting an error code -1 (if i put it in the SQL Editor, it works):

sql = update oitm set u_v33_defaultkitcode = 'FS' where itemcode = <dw_1.item.art1_id.value>

and this doesn't work either:

sql = update "OITM" set "U_V33_DefaultKitCode" = 'FS' where "ItemCode" = <dw_1.item.art1_id.value>

Comentarios

2 comentarios

Fecha Votos
  • Comment author
    Thierry Rodrigues da Silva

    Try like this

     

    sqlexecute=update oitm set "U_V33_DefaultKitCode" = 'FS' where "ItemCode" = '<dw_1.item.art1_id.value>'

    0
  • Comment author
    Michelle Campbell

    Thanks.  This is what ended up working:

    sqlca.update "OITM" set "U_V33_DefaultKitCode" = 'FS' where "ItemCode" = <dw_1.item.art1_id.value,dbstring>

    0

Iniciar sesión para dejar un comentario.