About the Employee Form

Quick Tour

Employee Form

The Employee form displays the fields of database EMP table and has functional buttons to allow the user to browse, add, update and query records. You can click on a button in the Employee Form window to learn how to code a particular function.

Each field corresponds to a column in the database EMP table. The Employee field is the indexed column and is mandatory for each record. The field datatypes and sizes are defined as follows in the EMP table:

Name Null? Type

------------------------------- -------- ----

EMPNO NOT NULL NUMBER(4)

ENAME VARCHAR2(10)

JOB VARCHAR2(9)

MGR NUMBER(4)

HIREDATE DATE

SAL NUMBER(7,2)

COMM NUMBER(7,2)

DEPTNO NOT NULL NUMBER(2)

The Employee Number (EMPNO) and Department (DEPTNO) columns are NOT NULL thus always require a value when a record is added. We enforce the length of each field by setting the MaxLength property of each TextBox to the appropriate number.