Page 238 - Open Soource Technologies 304.indd

Event Driven Programming

A screen-shot of the sample app at run-time is shown as follows:

10.4.2 Sample Applications 2 and 3: Using ADO Code

The Property database contains just one table called “Property”. The columns of this table are
defined as follows:

Column Name Data Type Notes

PROPNO Number (Long Integer) A number that uniquely identi
fies the property in the table.
Should be treated as the Primary
Key (although it is not defined
as such in the sample database).

EMPNO Number (Long Integer) A number that identifies the real
estate agent selling the property.
In a real system, this would be
the foreign key to the employee
number in an Employee table
(such a table is not present in the
sample database).

ADDRESS Text (20) The street address of the
property.

CITY Text (15) The city where the property is
located.

STATE Text (2) The state where the property is
located (2-characterUS state
abbreviation).
ZIP Text (5) The zip code where the property
is located.
NEIGHBORHOOD Text (15) The descriptive name of the
neighborhood in which the
property is located.

232 LOVELY PROFESSIONAL UNIVERSITY