assalamualaikumwarahmatullhiwabarokatuh...
setelah 2 minggu ade bermacam-macam bengkel..so srs haruslahh disiapkan..
soo minggu neh hanyaa bt srs shaja..
SRS OF KEBAJIKAN DAN DISIPLIN on goinggg~~
hantar pada en zul
checkk /
then hantar pada kak sukmaa
checkk
pastuh hantar pada pihak PTMK
checkk
dh approved semuaa pihakk baru laa blh beralih pada SDD^^
Thursday, November 15, 2012
[BENGKEL SRS] 5-8 NOV 2012
assalamualaikumwarahmatullahiwabarokatuh...
huh!!penatt wokkk penatt wokk!!Lepas je habis bengkel oracle form tuh..terus ade bengkel srs!!
Time : 5-8 NOV 2012
Vanue : INDRA SEMPURNA RESORT
Agenda : SRS Requirement with user
wokexx tujuann bengkel neh ade sb nk collect requirement dari user laa..yelahh user aku bz sgt..sb user aku neh asik ade program dgn student je kn..sb tuh laa kne ade kan bengkel neh..nk cek requirement ape y ade dh n ape y belum ade..
so
hari fes : HOSTEL MODULE by kak ita and m..
user : Pn Nora and Pn Noraini
hari second : KEBAJIKAN DAN DISIPLIN MODULE by aku and mimi
user : Pn Kamalia
hari ketiga : COCURRICULUM MODULE by alin and acik
user : En Faisal and En Rahman
: COUSELLING MODULE by En afif and normah
user : Pn Paridah
hari keempat : INTERGRATION SYSTEM
user : kesemua PTJ y terlibat ... Fin, BPA, JPPH and etc...
so skrg neh kami dh dpt 99% requirement daripada user..so blh start dh bt SRS
huh!!penatt wokkk penatt wokk!!Lepas je habis bengkel oracle form tuh..terus ade bengkel srs!!
Time : 5-8 NOV 2012
Vanue : INDRA SEMPURNA RESORT
Agenda : SRS Requirement with user
wokexx tujuann bengkel neh ade sb nk collect requirement dari user laa..yelahh user aku bz sgt..sb user aku neh asik ade program dgn student je kn..sb tuh laa kne ade kan bengkel neh..nk cek requirement ape y ade dh n ape y belum ade..
so
hari fes : HOSTEL MODULE by kak ita and m..
user : Pn Nora and Pn Noraini
hari second : KEBAJIKAN DAN DISIPLIN MODULE by aku and mimi
user : Pn Kamalia
hari ketiga : COCURRICULUM MODULE by alin and acik
user : En Faisal and En Rahman
: COUSELLING MODULE by En afif and normah
user : Pn Paridah
hari keempat : INTERGRATION SYSTEM
user : kesemua PTJ y terlibat ... Fin, BPA, JPPH and etc...
so skrg neh kami dh dpt 99% requirement daripada user..so blh start dh bt SRS
[BENGKEL ORACLE] AHAD : 4 NOV 2012
assalamualaikumwarahmatullhiwabarokatuh...
hari terakhir bengkel
pic : En Ahmad Ruszaini
tup tap tup tap
berakhir sudaa bengkel oracle form neh..
tp hari last neh aku xbt ape2 pun pasal oracle..
sebaliknye bt keje lain..bt report dgn sediakn template srs!!
sb esoknye ade bengkel srs plak!!
siann en ahmad..kteorg xdgr ckp dy!
nk bt mcm mne en. tbe2 je kak sukma suh bt template tuh..
dh laa nk print lagi..so xsempatt laa..huhu...
hbis je bengkel.tp BC..siapkan document lain..
hidangannn kerja di malam hari...
hari terakhir bengkel
pic : En Ahmad Ruszaini
tup tap tup tap
berakhir sudaa bengkel oracle form neh..
tp hari last neh aku xbt ape2 pun pasal oracle..
sebaliknye bt keje lain..bt report dgn sediakn template srs!!
sb esoknye ade bengkel srs plak!!
siann en ahmad..kteorg xdgr ckp dy!
nk bt mcm mne en. tbe2 je kak sukma suh bt template tuh..
dh laa nk print lagi..so xsempatt laa..huhu...
hbis je bengkel.tp BC..siapkan document lain..
hidangannn kerja di malam hari...
bekerjaa di BC smpaii malamm..yeahhh^^
esokkk ade bengkell srs di INDRA SEMPURNA RESORT selamaa 4 harii jugakk^^
[BENGKEL ORACLE] SABTU 3 NOV 2012
assalamualaikumwarahmatullahiwabarokatuh...
ari ketiga bengkel
pic : En Ahmad Ruszaini
arineh ari sabtu..org cuti tp aku ade bengkel..heee^^
aku p bengkel lmbt hari neh..sb p kedaii tayar lu..sb tayarr masuk paku...hee..
so harineh smbung chapter 11 smpai 20..^^
Chapter 11 - creating windows and content canvases
- windows can display multiple content canvases, but can display only one canvas at a time
- content canvases are display only in the window to which they are assigned
- you must assign at least one content canvas to each window in your application
- you create windows in the object navigator; one is created by default with each new module
Chapter 12 - working other canvas types
- the different types of canvases and their relationships to each other
- create a toolbar and tabbed interfaces
Chapter 13 - Introduction to Triggers
- Triggers are event-activated program units
- can categorize triggers based on function or name to help to understand how they work
- the execution hierarchy trigger property alters the firing sequence of a trigger.
Chapter 14 - Producing Triggers
- can use the PL/SQL Editor to write trigger code.
- trigger code has 3 sections
* declaration section (optional)
* Executable statements section (required)
* Exception handlers section (optional)
Chapter 15 - Debugging Triggers
Chapter 16 - Adding Functionality to Items
- use trigger to supplement the functionality of
-- input items:
When-[CheckBox | Radio]-Changed
When-List-[Changed | Activated]
-- noninput items:
WHen-Button-Pressed
When-Image-[Pressed | Activated]
When-Tree-Node-[Activated | Expended | Selected]
When-Custom-Item-Event
- can call usefull buitl-ins from triggers:
-- CHECKEDBOX_CHECKED
-- [ADD | DELETE]_LIST_ELEMENT
-- SHOW_LOV
-- [READ | WRITE]_IMAGE_FILE
-- FTREE : POPULATE_TREE, ADD_TREE_DATA,
[GET | SET]_TREE_PROPERTY
-- FBEAN: [GET | SET]_PROPERTY, INVOKE,
REGISTER_BEAN, ENABLE_EVENT
Chapter 17 - Run Time Message and Alerts
- Forms displays message at run time to inform the operator of events that occur in the sessions.
- 4 type of Form messages:
* Informative
* Error
* Working
* Application
Chapter 18 - Query Triggers
Chapter 19 - Validation
- Validating the Sales Representative item value by using an LOV
- writing a validation trigger to check that online orders are CREDIT orders
- Populating customer names, sales representative names, and IDs when a customer ID is changed
- writing a validation trigger to populate the name and the price of the product when the product ID is changed.
Chapter 20 - Navigation
huh!!habiss sudaahh sume chapter..En Ahmad ckp chap 21-25 xyh kuliah pun xpe..blh bace sndri..so bce sndrii jelah..erkk..bace ke..^^
ari ketiga bengkel
pic : En Ahmad Ruszaini
arineh ari sabtu..org cuti tp aku ade bengkel..heee^^
aku p bengkel lmbt hari neh..sb p kedaii tayar lu..sb tayarr masuk paku...hee..
so harineh smbung chapter 11 smpai 20..^^
Chapter 11 - creating windows and content canvases
- windows can display multiple content canvases, but can display only one canvas at a time
- content canvases are display only in the window to which they are assigned
- you must assign at least one content canvas to each window in your application
- you create windows in the object navigator; one is created by default with each new module
Chapter 12 - working other canvas types
- the different types of canvases and their relationships to each other
- create a toolbar and tabbed interfaces
Chapter 13 - Introduction to Triggers
- Triggers are event-activated program units
- can categorize triggers based on function or name to help to understand how they work
- the execution hierarchy trigger property alters the firing sequence of a trigger.
Chapter 14 - Producing Triggers
- can use the PL/SQL Editor to write trigger code.
- trigger code has 3 sections
* declaration section (optional)
* Executable statements section (required)
* Exception handlers section (optional)
Chapter 15 - Debugging Triggers
Chapter 16 - Adding Functionality to Items
- use trigger to supplement the functionality of
-- input items:
When-[CheckBox | Radio]-Changed
When-List-[Changed | Activated]
-- noninput items:
WHen-Button-Pressed
When-Image-[Pressed | Activated]
When-Tree-Node-[Activated | Expended | Selected]
When-Custom-Item-Event
- can call usefull buitl-ins from triggers:
-- CHECKEDBOX_CHECKED
-- [ADD | DELETE]_LIST_ELEMENT
-- SHOW_LOV
-- [READ | WRITE]_IMAGE_FILE
-- FTREE : POPULATE_TREE, ADD_TREE_DATA,
[GET | SET]_TREE_PROPERTY
-- FBEAN: [GET | SET]_PROPERTY, INVOKE,
REGISTER_BEAN, ENABLE_EVENT
Chapter 17 - Run Time Message and Alerts
- Forms displays message at run time to inform the operator of events that occur in the sessions.
- 4 type of Form messages:
* Informative
* Error
* Working
* Application
Chapter 18 - Query Triggers
Chapter 19 - Validation
- Validating the Sales Representative item value by using an LOV
- writing a validation trigger to check that online orders are CREDIT orders
- Populating customer names, sales representative names, and IDs when a customer ID is changed
- writing a validation trigger to populate the name and the price of the product when the product ID is changed.
Chapter 20 - Navigation
huh!!habiss sudaahh sume chapter..En Ahmad ckp chap 21-25 xyh kuliah pun xpe..blh bace sndri..so bce sndrii jelah..erkk..bace ke..^^
[BENGKEL ORACLE] JUMAAT: 2 NOV 2012
assalamualaikumwarahmatullahiwabarokatuh...
hari 2nd bengkel
pic : En. Ahmad Ruszaini
sambung chapter semalam..chapter 5 smpai chapter 10
untuk chapter 5 - Creating a Master for Detail Form
for this chapter kite akan dapat
1) Create data Blocks with relationship
-create by using data block wizard
-relation Object by using Object Navigator
-creating a relation manually
-join condition will creates primary-foreign key link between blocks
*define a join condition using:
- block and item names (not table and column names)
- Do not precede names with colon
- SQL equijoin syntax
- deletion properties
2) Modify a data block
-by using property palette
-Coordination Properties
* default
* deferred with auto query
* deferred without auto query
- running a master -detail from module
3) Modify the layout of a data block
- by using frame property palette - change property values
4) Run a master-detail form
untuk chapter 6 -Working with data Blocks and Frames
- Identify the components of the Property Palette
- Manage object properties
- Create and use Visual Attributes
- Control the behavior and appearance of data blocks
-control frame properties
- create blocks that do not directly correspond to database tables
- delete data blocks and their components.
dalam chapter 6 neh byk ajar pasal tukar2 font tukar2 kaler laa..lebey kurang gtuh laa...
Chapter 7 - Working with Text Items
- Text Item for Querying, inserting, updating, deleting
- Modifying the Appearance of a Text Item General and Physical Properties
* Modify he font and color properties
* Prompt
- Controlling the Data of a Text Item
* Format masks
--standard SQL Formats
--Nonstandard formats
- Adding Functionality to a Text Item
* Conceal Data Property
* keyboard Navigable and Enabled
* Multi-line Text Item
* Help Properties
Note: allow for formats mask's embedded characters when defining Width property.
Chapter 8 - Creating LOVs and Editors (list of values)
- Describe LOVs and Editors
- Design, cretae and associate LOVs with text items in a form module
- Create editors and associate them with text items in a form module.
Chapter 9 - Creating Additional Inputs Item
- Identify the item types that allow input
- create a check box
- create a list item
- create a radio group
- Converting a text item to , a list item, check box item, radio group
- also adding a radio buttons to the radio group.
Chapter 10 - Creating Noninput Items
- Identify items type that do not allow input
- create a display item
- create a button
- create a calculated item
- create a hierarchical tree item
- create a bean area item
cam bese dh habis bengkel silaa la bt exercisee yep^^
hari 2nd bengkel
pic : En. Ahmad Ruszaini
sambung chapter semalam..chapter 5 smpai chapter 10
untuk chapter 5 - Creating a Master for Detail Form
for this chapter kite akan dapat
1) Create data Blocks with relationship
-create by using data block wizard
-relation Object by using Object Navigator
-creating a relation manually
-join condition will creates primary-foreign key link between blocks
*define a join condition using:
- block and item names (not table and column names)
- Do not precede names with colon
- SQL equijoin syntax
- deletion properties
2) Modify a data block
-by using property palette
-Coordination Properties
* default
* deferred with auto query
* deferred without auto query
- running a master -detail from module
3) Modify the layout of a data block
- by using frame property palette - change property values
4) Run a master-detail form
untuk chapter 6 -Working with data Blocks and Frames
- Identify the components of the Property Palette
- Manage object properties
- Create and use Visual Attributes
- Control the behavior and appearance of data blocks
-control frame properties
- create blocks that do not directly correspond to database tables
- delete data blocks and their components.
dalam chapter 6 neh byk ajar pasal tukar2 font tukar2 kaler laa..lebey kurang gtuh laa...
Chapter 7 - Working with Text Items
- Text Item for Querying, inserting, updating, deleting
- Modifying the Appearance of a Text Item General and Physical Properties
* Modify he font and color properties
* Prompt
- Controlling the Data of a Text Item
* Format masks
--standard SQL Formats
--Nonstandard formats
- Adding Functionality to a Text Item
* Conceal Data Property
* keyboard Navigable and Enabled
* Multi-line Text Item
* Help Properties
Note: allow for formats mask's embedded characters when defining Width property.
Chapter 8 - Creating LOVs and Editors (list of values)
- Describe LOVs and Editors
- Design, cretae and associate LOVs with text items in a form module
- Create editors and associate them with text items in a form module.
Chapter 9 - Creating Additional Inputs Item
- Identify the item types that allow input
- create a check box
- create a list item
- create a radio group
- Converting a text item to , a list item, check box item, radio group
- also adding a radio buttons to the radio group.
Chapter 10 - Creating Noninput Items
- Identify items type that do not allow input
- create a display item
- create a button
- create a calculated item
- create a hierarchical tree item
- create a bean area item
cam bese dh habis bengkel silaa la bt exercisee yep^^
Thursday, November 1, 2012
[BENGKEL ORACLE] KHAMIS : 1 NOV 2012
assalamualaikumwarahmatullahiwabarokatuh..
hari fes bengkel
pic :
untuk setengah hari neh kami sume install oracle form aje..
oracle form 11g ditukarkn pada oracle form 10g
so install
1-database oracle 32bit
2-oracle form 10g
kalu gune oracle form 10g xyh nk install web logic..n lagi ok dari oracle form 11g
INSTALL ORACLE DEVELOPER SUIT 10g WIN7
1. Database - Setup
2. Right click "setup" - Properties
3. select "compatibility" section
4. compatibility mode - untick windows xp (service pack 3)
5. Display setting - "Disable display scalling on high DPI settings"
6. Privilege Level - Run as Administrator
7. Apply
8. Ok
INSTALLATION
if Error, check SWAP SPACE
1. mycomputer - Properties
2. Advanced system setting - Performance section - settings
3. Advanced - virtual memory section - change
4. "select driver"- enter min size > 1535
if kalu xingt database name
1. go to SQL Plus
2. select name from v$database;
if lock oe and hr
sql plus
SQL>alter user oe account unlock
SQL>alter user oe identified by admin
Connection to database to the form builder
-use netscape with jinitiator plugin..
do exercise 4: create new folder^^
- exercise done^^
hari fes bengkel
pic :
untuk setengah hari neh kami sume install oracle form aje..
oracle form 11g ditukarkn pada oracle form 10g
so install
1-database oracle 32bit
2-oracle form 10g
kalu gune oracle form 10g xyh nk install web logic..n lagi ok dari oracle form 11g
INSTALL ORACLE DEVELOPER SUIT 10g WIN7
1. Database - Setup
2. Right click "setup" - Properties
3. select "compatibility" section
4. compatibility mode - untick windows xp (service pack 3)
5. Display setting - "Disable display scalling on high DPI settings"
6. Privilege Level - Run as Administrator
7. Apply
8. Ok
INSTALLATION
if Error, check SWAP SPACE
1. mycomputer - Properties
2. Advanced system setting - Performance section - settings
3. Advanced - virtual memory section - change
4. "select driver"- enter min size > 1535
if kalu xingt database name
1. go to SQL Plus
2. select name from v$database;
if lock oe and hr
sql plus
SQL>alter user oe account unlock
SQL>alter user oe identified by admin
Connection to database to the form builder
-use netscape with jinitiator plugin..
do exercise 4: create new folder^^
- exercise done^^
Subscribe to:
Posts (Atom)