 |
| Creating a Master-Detail Form |
1. Write down about Template forms? How can create a form based on a Template?
Template forms typically include generic objects, such as graphics, toolbars, and program units. We can define standard window layouts, standards, and other common objects that we want to include in new forms.
Creating a form based on a template:
• Start forms builder. In the welcome to the forms builder dialog box, select the “build a form based on a template” option, and then click ok.
• Select file>New>form using template from the menu.
2. How to create a relation manually?
To explicitly create a relation, perform the following steps :
I. Select the relations node under the master block entry in the object navigator.
II. Click the create icon. The new relation window is displayed.
III. Specify the name of the detail block.
IV. Choose our master delete property.
V. Choose our coordination property.
VI. Specify the join condition.
VII. Click ok.
3. Shortly brief about join condition?
The join condition creates primary key-foreign key link between blocks.
Use a join condition to:
• Create links between blocks using SQL
• Alter links between blocks using SQL
Define a join condition using:
• Usual SQL equijoin condition syntax.
• Block names instead of the base table names.
• Item names that exist in the form module instead of base table column names.
4. Shortly brief about Master-Detail relationship?
A master-detail relationship is an association between two data blocks that reflect a primary key relationship between the database tables on which the two data blocks are based. The master data block is based on the table with the primary key, and the detail data block is based on the table with the foreign key. A master-detail relationship equates to the one-to-many relationship in the entity relationship diagram.
5. What is data block functionality?
After we create a data block with the wizards, forms builder automatically creates:
• A form module with database functionality including query, insert, update, and delete.
• A frame object.
• Items in the data block.
• A prompt for each item.
• Triggers needed to enforce database constraints if “enforce data integrity” is selected.
6. Define Master-Detail Relationship.
A Master-detail relationship is an association between two data blocks that reflects a primary key-foreign key relationship between the database tables on which the two data blocks are based.
7. Write about Deletion properties.(VIQ) Ans.
• Isolated-Only Master is deleted
• Cascading-Master and all details are deleted
• Non Isolated- If no detail record master is deleted, But master is not deleted if there are any detail record .
8. What is Join Condition?
The join condition creates primary-foreign key link between blocks. Define a join condition using:
- Block and item names & Do not precede names with colon.
- SQL equijoin syntax.
9. Write down the structure of master-detail Relationship?
The following are examples of the master-detail structure:
• Master-detail: Order-items
• Master-detail-detail: Customer-order-items
• Master-2*detail: Customer-order and customer-account reps
0 Comments