project.lock(); OrderQuery = database.cursor("select order_header.order_no, order_header.customer_no, order_header.customer_po, order_header.order_date, order_line.order_no, order_line.line_no, order_line.item_no, order_line.location, order_line.qty_ordered, order_line.qty_shipped, order_line.price, customer.customer_name, item_master.description from order_header, order_line, customer, item_master where order_header.order_no = '" + request.OrderNumber + "' and order_line.order_no = order_header.order_no and customer.customer_no = order_header.customer_no and item_master.part_no = order_line.item_no") write(""); //write(""); write("" + ""); write(""); write("" + "" + "" + ""); write("
Query Selections
Query Selections" + "
Order Number:" + request.OrderNumber + "
"); write(""); write(""); write("" + ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""); var no_data = "Y"; var bo_qty = 0; var bo_amt = 0; while(OrderQuery.next()){ no_data = "N"; if (OrderQuery.qty_shipped > 0 && OrderQuery.qty_shipped != OrderQuery.qty_ordered){ bo_qty = OrderQuery.qty_ordered - OrderQuery.qty_shipped; bo_amt = bo_qty * OrderQuery.price; } write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); } write("
Order Status By Order Number
Customer NoCustomer NameCust P.O.Order NoOrder DateLine NoItem NoDescriptionQty OrdQty ShippedPriceQty B.O.$ B.O.
" + OrderQuery.customer_no + "" + OrderQuery.customer_name + "" + OrderQuery.customer_po + "" + OrderQuery.order_no + "" + OrderQuery.order_date + "" + OrderQuery.line_no + "" + OrderQuery.item_no + "" + OrderQuery.description + "" + OrderQuery.qty_ordered + "" + OrderQuery.qty_shipped + "" + OrderQuery.price + "" + bo_qty + "" + bo_amt + "
"); if(no_data == "Y") write("No Data Matches Your Selections"); project.unlock();