Home | Projects | Banking System | Form: City Mast

Form: City Mast

By
Font size: Decrease font Enlarge font

Form is used for creating updating Records for various information that are stored in city_mast table

Sample Layout Design for The form City_mast form

Form for creating and updating records as per the screen above.

Form associate with table CITY_MAST

Blocks 2

control block 1

database block 1

User first select CREATE or UPDATE radio buttons. currently we work only on CREATE mode, on selecting CREATE Radio UPDATE radio button and city code is deactivated ( Non Navigable by cursor..

Following is the navigation sequence of cursor when in CREATE mode

CITY NAME, DIAL CODE, CITY_TYPE, STATE NAME, COUNTRY NAME , SAVE.

city_code is self generted and the city code field is protected against update and cursor cannot navigate to city code field in CREATE MODE

cursor is navigate to city_name field, this field cannot be blank and also if duplicate city name if generated user should get an alert.

After this cursor navigates to dial code field, validation check for dial code is only numbers to be generated and not alpha numberic data to be generated in dial code filed.

CITY TYPE is a pop list item and user can select city type from drop down POP list (Predefined Options are VILLAGE, TEHSIL, DISTRICT)

CITY NAME after CITY TYPE, cursor to navigate to CITY NAME field should not be null and user should get an ALERT incase duplicate name.

STATE NAME after CITY NAME , cursor to navigate to STATE NAME LOV should be present and user to select state name from LOV that is activated and STATE NAME and STATE CODE value to be retrieveed from the LOV.

COUNTRY NAME after COUNTRY NAME , cursor to navigate to COUNTRY NAME LOV should be present and user to select COUNTRY NAME from LOV that is activated, COUNTRY NAME and COUNTRY CODE value to be retrieveed from the LOV.

SAVE button: saves all the entries and cursor navigates to CREATE UPDATE radio button (both create and update radio button to be again activate) and whole procedure as state above is repeated.

NAVIGATION  to field to be done by

TAB / ENTER KEY

DOWN ARROW USER TO navigate to next navigable item.

UP ARROW USER TO navigate to previous navigable item.

SOME TIPs FOR FOLLOWING

1. HOW TO DEACTIVATE UPDATE RADIO BUTTON

>> Click is the event that can be triggered on selecting either of the RADIO BUTTONS. A value will always be retured on selecting either of the RADIO BUTTON ( Create / Update). Say is value returned is 1 on selecting CREATE Radio Button and 2 on selecting UPDATE RADIO BUTTON,

Since we have to deacivate UPDATE BUTTON we can have a trigger text

if :crreatupdate = 1 then

Actions trigger text

else if

:crreatupdate = 2 then

action trigger text

End if;

NOTE: IN THE CURRENT FORM, ONE SHOULD HAVE BOTH RADION BUTTON (CREATE/UPDATE ) IN SAME RADIO GROUP.

2. HOW TO ENSURE THAT SAME NAME IS NOT REPEATED

>> After generating the city name, check if same name is already stored in the table. A trigger text (Implicit PLSQL statement with very basic query) on relevant trigger name ( event ) can be written. This can always provide validational check for duplicate name, if same is already generated in database ( CITY MAST Table)

NOTE: DEFINING UNIQUE CONSTRAINT IN TABLE CANNOT BE A SOLUTION AN CITY NAME ALSO THERE CAN BE TYPOE LEADING DUPLICATION BUT NOT VOILATING UNIQUE CONSTRAINT. WITH OPTIMUM TRIGGER TEXT THIS CONTROL IS POSSIBLE WITHOUT DEFINING UNIQUE CONSTRAINT

Subscribe to comments feed Comments (0 posted)

total: | displaying:

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

Captcha
  • Email to a friend Email to a friend
  • Print version Print version
  • Plain text Plain text

Tagged as:

No tags for this article

Rate this article

0