BEAS Script to Delete Record

Michelle Campbell

The following works, but would rather delete the reservation lines instead of zeroing them out.  Anyway to do that?

if <dw_1.item.status_id.value> = 'PCK' then
    sqlca.update "BEAS_RESERVATION_LINE" set "Quantity"=0 where "BASE_DOCENTRY" = <dw_1.item.belnr_id.value> and "BASE_LINENUM" = <dw_1.item.belpos_id.value>
end if

Comments

0 comments

Please sign in to leave a comment.