BUILT_IN SUB PROGRAMS USED IN FORMS TRIGGERS:
----------------------------------------------------------------------------------
commit_form - used to save changes (valid for DML)
clear_form - clears all the blocks in form & place cursor in first block.
clear_block - clears the current block
clear_record - clears current record
clear_item - clears current text item
exit_form - quits the application
next_block - moves to the next block in sequence
previous_block - moves to the previous block
go_block('Block name') - go_block('student');
place the cursor in the block specified.
next_record - moves to next record
previous_record - moves to previous record
first_record - moves to first record
last_record - moves to last record
next_item - place the cursor in next item( TAB key )
previous_item - place the cursor in previous item
go_item(' blockname.itemname ') - place the cursor in specified item.
show_view('canvas') - used to display canvas programatically
hide_view('canvas') - used to hide the canvas
enter_query - prompts to accept a condition for query
execute_query - retrieves data from tables into block
abort_query - cancel query
show_alert('alert name') - Used to display alert at runtime
show_lov('lov name') - Used to display LOV at runtime
set_lov_property - Used to change lov properties at runtime
set_alert_property - Used to change alert properties at runtime
set_alert_button_property - Used to change properties of alert buttons at runtime
set_block_property -Used to change properties of block
set_item_property - Used to change properties of item
set_window_property - Used to change properties of window
create_record - used to add new record(insert) -It clears the screen and allows to insert a record.
delete_record - used to remove a record - applied to the current record pointed by cursor.
message(' message text '||variable); - used to print messages
Call_form - used to call a Form from existing Form - used for navigation between Forms
run_product - used to run the other products of Developer 6i from forms runtime environment. ex: Graphics, Reports
Image Item Description
*read_image_file - Retrieves the image into image item from OS file ( file to image item).
read_image_file(source,'image format',target);
source - Os file Target - Image item
image format - Type of image (bmp,jpeg,tiff)
* write_image_file - Stores the image into OS file (image item to file)
write_image_file(target,'image format',source);
Target - Os file source - Image item
Image item Properties:
* sizing style - crop or adjust
adjust - fix the picture into image item
(Picture will be compressed to image item size)
crop - stores the picture in original size (default)
* show palette - yes/no
* image format - bmp/tiff/......etc
----------------------------------------------------------------------------------
commit_form - used to save changes (valid for DML)
clear_form - clears all the blocks in form & place cursor in first block.
clear_block - clears the current block
clear_record - clears current record
clear_item - clears current text item
exit_form - quits the application
next_block - moves to the next block in sequence
previous_block - moves to the previous block
go_block('Block name') - go_block('student');
place the cursor in the block specified.
next_record - moves to next record
previous_record - moves to previous record
first_record - moves to first record
last_record - moves to last record
next_item - place the cursor in next item( TAB key )
previous_item - place the cursor in previous item
go_item(' blockname.itemname ') - place the cursor in specified item.
show_view('canvas') - used to display canvas programatically
hide_view('canvas') - used to hide the canvas
enter_query - prompts to accept a condition for query
execute_query - retrieves data from tables into block
abort_query - cancel query
show_alert('alert name') - Used to display alert at runtime
show_lov('lov name') - Used to display LOV at runtime
set_lov_property - Used to change lov properties at runtime
set_alert_property - Used to change alert properties at runtime
set_alert_button_property - Used to change properties of alert buttons at runtime
set_block_property -Used to change properties of block
set_item_property - Used to change properties of item
set_window_property - Used to change properties of window
create_record - used to add new record(insert) -It clears the screen and allows to insert a record.
delete_record - used to remove a record - applied to the current record pointed by cursor.
message(' message text '||variable); - used to print messages
Call_form - used to call a Form from existing Form - used for navigation between Forms
run_product - used to run the other products of Developer 6i from forms runtime environment. ex: Graphics, Reports
Image Item Description
*read_image_file - Retrieves the image into image item from OS file ( file to image item).
read_image_file(source,'image format',target);
source - Os file Target - Image item
image format - Type of image (bmp,jpeg,tiff)
* write_image_file - Stores the image into OS file (image item to file)
write_image_file(target,'image format',source);
Target - Os file source - Image item
Image item Properties:
* sizing style - crop or adjust
adjust - fix the picture into image item
(Picture will be compressed to image item size)
crop - stores the picture in original size (default)
* show palette - yes/no
* image format - bmp/tiff/......etc