project.lock(); DelSchQuery = database.cursor("select delivery_schedule.delivery_schedule, delivery_schedule.quantity, delivery_schedule.promise_date, delivery_schedule.request_date from delivery_schedule where delivery_schedule.order_no = '" + request.OrderNumber + "' and delivery_schedule.line_no = '" + request.LineNo + "'") ShpFlrQuery = database.cursor("select shop_floor.operation_sequence, shop_floor.qty_ordered, shop_floor.qty_complete, shop_floor.start_date, shop_floor.due_date, order_line.shop_order_no from shop_floor, order_line where order_line.order_no = '" + request.OrderNumber + "' and order_line.line_no = '" + request.LineNo + "' and shop_floor.shop_order_no = order_line.shop_order_no order by operation_sequence") write(""); write("" + "" + ""); write(""); write("" + "" + "" + "" + "" + "" + "" + ""); write("
Query Selections
Order Number:" + request.OrderNumber + "Line Number:" + request.LineNo + "
"); write(""); write(""); write("" + ""+ ""+ ""+ ""+ ""); var no_data = "Y"; while(DelSchQuery.next()){ no_data = "N"; write(""); write(""); write(""); write(""); write("") write(""); } write("
Delivery Schedule Detail
Delivery ScheduleQuantityPromise DateRequest Date
" + DelSchQuery.delivery_schedule + "" + DelSchQuery.quantity + "" + DelSchQuery.promise_date + "" + DelSchQuery.request_date + "
"); if(no_data == "Y") write("No Data Matches Your Selections"); write(""); write(""); write("" + ""+ ""+ ""+ ""+ ""+ ""+ ""); no_data = "Y"; while(ShpFlrQuery.next()){ no_data = "N"; write(""); write(""); write(""); write(""); write(""); write(""); write("") write(""); } write("
Shop Floor Detail
Shop Floor NoOperation SequenceQuantity OrderedQuantity CompleteStart DateDue Date
" + ShpFlrQuery.shop_order_no + "" + ShpFlrQuery.operation_sequence + "" + ShpFlrQuery.qty_ordered + "" + ShpFlrQuery.qty_complete + "" + ShpFlrQuery.start_date + "" + ShpFlrQuery.due_date + "
"); if(no_data == "Y") write("No Data Matches Your Selections"); project.unlock();