Return to README.rtf CVS log

Up to [NeXTSTEP 3.3 examples] / Examples / DatabaseKit / OracleDemo

Annotation of Examples/DatabaseKit/OracleDemo/README.rtf, revision 1.1.1.1

1.1       root        1: {\rtf0\ansi{\fonttbl\f0\fswiss Helvetica;\f2\fmodern Ohlfs;}
                      2: \paperw10800
                      3: \paperh11780
                      4: \margl120
                      5: \margr100
                      6: {\colortbl;\red0\green0\blue0;}
                      7: \pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\f0\b\i0\ulnone\fs36\fc0\cf0 OracleDemo
                      8: \b0\fs24 \
                      9: by Mai Nguyen, NeXT Developer Support Team\
                     10: \
                     11: 
                     12: \b\fs28 Overview
                     13: \b0\fs24 \
                     14: \
                     15: The purpose of this example is to show some common  end-user operations in handling databases 
                     16: \b without any need for Database Kit programming.
                     17: \b0   \
                     18:  In order to run this example, you need to have an Oracle server with a demo database installed. If you don't have an Oracle server, you can still follow the instructions on building the nib files to quickly put together a demo.\
                     19:  \
                     20:  In order to add a new record  either into the employee table or the department table, press on the appropriate 
                     21: \b Insert 
                     22: \b0 button and  type in the data into the tableview textfields. After each 
                     23: \b Insert 
                     24: \b0 operation, you need to explicitly 
                     25: \b save 
                     26: \b0 the record. Note that the unique keys for the Employee Record is the Employee ID, while the unique key for the Department Record is the Department No. Similarly, after a 
                     27: \b delete 
                     28: \b0 operation, you'll need to explicitly 
                     29: \b save 
                     30: \b0 the changes.\
                     31: 
                     32: \fc1\cf1 \
                     33: 
                     34: \b\fs28 Program Organization
                     35: \b0\fs24 \
                     36: \
                     37: 
                     38: \b How to build the nib files\
                     39: 1) Build the Master TableView
                     40: \b0 \
                     41: Drag a DBTableView palette object into your main window. Drag a DBModule object into the IB suitcase. Select OracleDemo as the database model. Make the proper connections from the Deparment table  to the DBTableView. Set  the DBTableView to be editable via the Interface Builder Inspector Panel, so that data can be entered directly into its textfields.\
                     42: 
                     43: \b 2) Build the Detail TableView\
                     44: 
                     45: \b0 Same steps as for the Mater TableView. The only difference is that you need to drag another DBModule object into the IB suitcase, and make the proper connections from the Employee table to the DBTableView.\
                     46: 
                     47: \b 3) Join the 2 tables
                     48: \b0 \
                     49: In order to join the 2 tables,  just drag and drop the employees relationship in the master DBModule onto the icon of the detail module in the NIB file. Note that employees will show up as a new connection of the Master DBModule under the Interface Builder Inspector Panel.\
                     50: 
                     51: \b 4) Build the buttons\
                     52: 
                     53: \b0 Note that the Fetch operation needs to be connected to the fetchAllRecords of the Master DBModule.\
                     54: Each TableView has its own insert, delete, and save to save the records corresponding to that particular table.\
                     55: 
                     56: \pard\tx560\tx1120\tx2060\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\fi-2060\li2060\fc1\cf1 \
                     57: 
                     58: \pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b\fc1\cf1 Note: 
                     59: \b0 You can use this NIB file as is without any coding for demo purposes and run it using IB Test Interface Mode. 
                     60: }

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.