Beas Script Error for SQL

Michelle Campbell

• November 12, 2024 22:05
• Edited

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>

Vote

0

• 

  Thierry Rodrigues da Silva

  • November 14, 2024 13:05

  Try like this

   

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

  Michelle Campbell

  • November 14, 2024 18:32

  Thanks.  This is what ended up working:

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

Please sign in to leave a comment.