Recitation08v02Supplement - 1 3/12/2009 ORIE 3120...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 3/12/2009 ORIE 3120 Industrial Data and Systems Analysis Recitation 8 Supplement User Interface Programming Created by Peter Jackson Edited by Keerati Winyoopradist and Andrew Yongvanich 1. This is a continuation of recitation 8. Create a User Interface to the Data (OPTIONAL) 1. The rest of this tutorial is OPTIONAL. It will not be covered on the exam. 2. We are going to let the user select a purchased part to analyze. Create a table to hold the selected part number. 3. To start, open the table and enter the product ID 23055-6: Make sure there is only a single record in the table. 4. Create a query that selects only the flow events associated with the select productID. 5. Remember to look at the SQL code. 6. Open the query. 2 3/12/2009 There are 96 records in the query. Looks like I didnt get the inventory starting date quite right: there is an outflow on July 13, 2005 for this component. Dont worry about this: it is close enough for graphical purposes. Also, note how fast this query is. That is important for the user interaction. 7. We want to display these data as a cumulatives. You should be comfortable creating the following type of query: 8. The SQL code is: 9. The query result is: 3 3/12/2009 10. We have only one more query to create and then we can switch over to user interface programming. When we are presenting the user with a dropdown list of purchased parts to choose from, we can control the sort order of the parts. If we just give the user the parts in alphabetical order, it will be like giving them a randomly ordered list. Finding interesting charts to look at will be difficult. Instead, lets sort the parts by some field that will likely put interesting charts near the beginning. Here is what I chose: 11. Open the query Q230. 4 3/12/2009 The purchased parts near the top of this list are likely to have interesting cumulative...
View Full Document

This note was uploaded on 03/18/2012 for the course ORIE 3120 taught by Professor Jackson during the Spring '09 term at Cornell University (Engineering School).

Page1 / 26

Recitation08v02Supplement - 1 3/12/2009 ORIE 3120...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online