Really frustrated I have composed the method below:
- Code: Select all
function get_bom_items_pt_1() {
globals.bb_so_order_id = forms.opl_frm_order_lines.soh_order_number
forms.dev_order_lines_table.controller.show()
forms.dev_order_lines_table.controller.find()
forms.dev_order_lines_table.sor_order_id = globals.bb_so_order_id
forms.dev_order_lines_table.sor_bom_master = "1"
forms.dev_order_lines_table.controller.search()
while (databaseManager.getFoundSetCount(forms.dev_order_lines_table.foundset) > 0) {
globals.bb_product_id = forms.dev_order_lines_table.sor_product_code
globals.bb_bom_master_qty = forms.dev_order_lines_table.sor_quantity
forms.dev_bom.controller.show()
forms.dev_bom.controller.find()
forms.dev_bom.bom_parent = globals.bb_product_id
forms.dev_bom.controller.search()
while (databaseManager.getFoundSetCount(forms.dev_bom.foundset) > 0) {
globals.bb_component_id = forms.dev_bom.bom_child
globals.bb_bom_qty = forms.dev_bom.bom_child_qty
forms.dev_order_lines_table.controller.show()
forms.dev_order_lines_table.controller.newRecord()
forms.dev_order_lines_table.company_id = globals.bb_company_id
forms.dev_order_lines_table.sor_order_id = globals.bb_so_order_id
forms.dev_order_lines_table.sor_product_code = globals.bb_component_id
forms.dev_order_lines_table.sor_operational = "1"
forms.dev_order_lines_table.sor_po_qty = globals.bb_bom_qty * globals.bb_bom_master_qty
forms.dev_bom.controller.show()
forms.dev_bom.controller.omitRecord()
}
forms.dev_order_lines_table.controller.omitRecord()
}
}
However, it only seems to work when there is a breakpoint set at the second while statement. Can anyone help with this? This is my first largish method and I have found it quite laborious....
Thanks in advance