\b0\fs24 by Mai Nguyen, NeXT Developer Support Team\
\b\fs28 Overview
\b0\fs24 \
In order to run this example, you need to have a SYBASE server with a pubs database installed. The pubs database is a sample database provided with the SYBASE limited server package. \
You also have to install the
\b SybaseDemo.dbmodel
\b0 from /NextDeveloper/Examples/DatabaseKit/models into your
\b ~/Library/Databases
\b0 directory, in order to establish the proper connections between the database model and the Database Kit UI Objects.\
The purpose of this example is to show you how to quickly put together a simple database application without much programming by taking advantage of the Database Kit UI Objects such as DBTableView and DBModule.\
After you are properly connected to the Sybase server, you can perform operations such as
\b Select
\b0 ,
\b Insert
\b0 ,
\b Save
\b0 or
\b Delete
\b0 . Note that an
\b Insert
\b0 or
\b Delete
\b0 won't take effect in the database until a
\b Save
\b0 operation is performed. All operations such as
\b Save
\b0 ,
\b Delete
\b0 and
\b Select
\b0 are almost done without any coding. For simplicity's sake, there is no verification of the data entered via the FormCells for a
\b Save
\b0 or
\b Insert
\b0 operation.\
\b\fs28\fc1\cf1 Preferences Setting\
\b0\fs24 \
You can retrieve the data in ascending or descending order by selecting the Sort Order with the Radio buttons. Note that the tag values of these Radio Buttons correspond to the actual constants defined in dbkit/enums.h.\
You can either select all records by default, or qualify them by state of residence by entering the proper state into the textfield.\
\b\fs28 Program Organization
\b0\fs24 \
\b Major Classes in &C2
Application
\b0 \
\pard\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-1900\li1900\fc1\cf1 Controller A general manager object. A subclass of the Object class. Performs miscellaneous initialzations and operations such as inserting, selecting and sorting.\
\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b\fc1\cf1 Other Peculiarities
\b0 \
The primary key for inserting a new record is the social security number. It is not possible to insert a new record with a duplicate id (or social security number). \
In order to load an Adaptor dynamically, you need to add the
\b OTHER_LDFLAGS
\b0 definition (see the
\b Makefile.preamble
\b0 ). You also need to add the
\b libdbkit_s.a
\b0 library into your
\b IB.project
\b0 under
\b libraries
\b0 in order to use the DBKit API. \
\b\fs28 Topics Of Interest\
\b0\fs24 \
The purpose of this example is to show you some simple examples of the usage of the DBKit UI Objects:\
\b How to qualify a select operation using DBQualifier\
\b0 See the method
\b buildSelectQualifier:
\b0 in the file Controller.m\
\b How to insert a new record to a database via the DBFetchGroup object
\b0 \
See the delegate method
\b fetchGroup:didInsertRecordAt:
\b0 in the file Controller.m\
\b How to use a DBBinder object to evaluate some arbitrary SQL query connected with the Pubs database:
\b0 \
See the method
\b evaluateSQL:
\b0 in the file Controller.m. Note that the DBBinder method evaluateString: only returns properties as results of the query. Instead of an arbitrary SQL query, one can also pass a Sybase stored procedure to the binder.\
(.txt)