设置光标所在记录的状态:
set_record_property(name_in('system.trigger_record'),'gme_batch',status,query_status);
注意cursor_record,current_record,trigger_record之间的区别,有空研究一下。
Check_Package_Failure
do_key('PREVIOUS_BLOCK');
hide_window('gme_lot');
copy(:gme_btn.sum_lot_qty,'gme_batch.trx_qty');
post ;--后台自己提交数据
转换库存主单位对应辅单位的数量:
l_second_qty := inv_convert.inv_um_convert(:gme_batch.inventory_item_id,'',:gme_batch.organization_id,38,:gme_batch.sum_lot_qty,:gme_batch.primary_uom_code,:gme_batch.secondary_uom_code,'','');
当在FORM中使用了RAISE FORM_TRIGGER_FAILURE,而又写了
exception
when others then
message(sqlerrm);
RAISE FORM_TRIGGER_FAILURE;
有时会报error:100501:non-