Button SAVE

Create data block eg. COURSE_BLOCK
Add text item eg COURSE_NAME, COURSE_TIME, ROOM

* Pada data_block i.e COURSE_BLOCK x perlu isi 'Query Data Source Type' dan 'Query Data Source Name' sbb bukannya nak display data. Ini untuk input data dan save ke dalam database. Jika tidak button 'SAVE' takkan berfungsi.

Trigger untuk button 'SAVE'

begin
if :course_block.course_name is not null then
   insert into course (course_name, course_time, room)
   values (:course_block.course_name, :course_block.course_time, :course_block.room);
   message ('1 RECORD WAS INSERTED');
else
   message ('You need to specify a valid course name');
end if;
exception
   when dup_val_on_index then
   message ('A course with this name already exists.');
end;

* tambah 'commit;'

begin
if :course_block.course_name is not null then
   insert into course (course_name, course_time, room)
   values (:course_block.course_name, :course_block.course_time, :course_block.room);
   message ('1 RECORD WAS INSERTED');
   commit;
else
   message ('You need to specify a valid course name');
end if;
exception
   when dup_val_on_index then
   message ('A course with this name already exists.');
end;