Current Feed Content from 26 Nov 08 12:46
HOW MANY RELATION SHIPS WE HAVE
Tue, 19 Aug 2008 18:19:00 +0000Isolated, non isolated and cascadenoreply@blogger.com (kate putin)ON-INSERT
Tue, 19 Aug 2008 18:19:00 +0000Fires during the Post and Commit Transactions process when a record is inserted. Specifically, it fires after the Pre-Insert trigger fires and before the Post-Insert trigger fires, when Form Builder would normally insert a record in the database. It fires once for each row that is marked for insertion into the databasenoreply@blogger.com (kate putin)PRE-INSERT
Tue, 19 Aug 2008 18:18:00 +0000Fires during the Post and Commit Transactions process, before a row is inserted. It fires once for each record that is marked for insert.noreply@blogger.com (kate putin)POST QUERY
Tue, 19 Aug 2008 18:17:00 +0000When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for each record placed on the block's list of records.
Perform an action after fetching a record, such as looking up values in other tables based on a value in the current record. Fires once for each record fetched into the blocknoreply@blogger.com (kate putin)THE REPORT from FORM
Tue, 19 Aug 2008 18:15:00 +0000Using run product () we can call the report from the form.
Syntax: Run Product (REPORTS, 'report name ', SYNCHRONOUS, RUNTIME, FILESYSTEM, id, NULL);noreply@blogger.com (kate putin)Differences among NEW FORM, OPEN FORM, CALL FORM
Tue, 19 Aug 2008 18:09:00 +0000Call form is an unrestricted procedure,
Open form and new form are restricted procedures.
. Form Builder maintains any locks (obtained by a form) across OPEN_FORM (in the same session), CALL_FORM and NEW_FORM procedure calls.noreply@blogger.com (kate putin)NEW FORM, OPEN FORM, CALL FORM
Mon, 18 Aug 2008 06:31:00 +0000NEW_FORM
To replace the current form in an application, execute the NEW_FORM.
Once we open new form, we can’t come back to the old form
OPEN_FORM
When a form executes OPEN_FORM to invoke another form, the first form remains displayed, and end users can navigate between the forms as desired. An opened form can share the same database session as the form from which it was invoked.
CALL_FORM
When a form executes CALL_FORM to invoke another form, the called form is modal with respect to the calling form. Any windows that belong to the calling form are not usable until the called form is exited and control returns to the calling form.noreply@blogger.com (kate putin)How To Call FORM from ANOTHER FORM
Mon, 18 Aug 2008 06:29:00 +0000By using call form and open form we can call another form.
Syntax: call form (destination form name),
Open form (destination form name)noreply@blogger.com (kate putin)LIBRARY
Mon, 18 Aug 2008 06:25:00 +0000A library is a collection of subprograms, including user-named procedures, functions, and packages.
Libraries provide a convenient means of storing client-side program units and sharing them among multiple applicationsnoreply@blogger.com (kate putin)EXECUTION HIERARCHY OF TRIGGERS
Mon, 18 Aug 2008 06:22:00 +0000Form level
^
|
|
|
Block level
^
|
|
|
Record level
^
|
|
|
Block level
^
|
|
|
Item level
^
|
|
|noreply@blogger.com (kate putin)OBJECT GROUPS
Mon, 18 Aug 2008 06:20:00 +0000An object group is a container for a group of objects. You define an object group when you want to package related objects so you can copy or subclass them in another module. Object groups provide a way to bundle objects into higher-level building blocks that can be used in other parts of an application and in subsequent development projectsnoreply@blogger.com (kate putin)CONTROL BLOCK
Mon, 18 Aug 2008 06:19:00 +0000A control block is not associated with the database, and the items in a control block do not relate to table columns within a database.noreply@blogger.com (kate putin)DATA BLOCK
Mon, 18 Aug 2008 06:18:00 +0000Data blocks are associated with data within a database. By default, the association between a data block and the database allows operators to automatically query, update, insert, and delete rows within a database.Data blocks can be based on database tables, views, procedures, or transactional triggers.noreply@blogger.com (kate putin)WHEN WE WILL USE STACKED CANVAS
Mon, 18 Aug 2008 06:16:00 +0000Normally only one canvas will be displayed on application window at run time, if we want to display more than one canvas at a time then we will go for stacked canvas. This canvas displayed on the top of application window, content canvas.noreply@blogger.com (kate putin)WHAT IS THE DEFAULT CANVAS
Mon, 18 Aug 2008 06:14:00 +0000Content canvasnoreply@blogger.com (kate putin)TYPES OF CANVAS
Mon, 18 Aug 2008 06:13:00 +0000• Content
• Stacked
• Tab
• Horizontal tool bar
• Vertical tool barnoreply@blogger.com (kate putin)What are Packaged Procedures
Mon, 28 Jul 2008 06:58:00 +0000A PACKAGED PROCEDURE is a built-in PL/SQL procedure that is available in all forms. Each packaged procedure executes a SQL*FORMS function, such as moving to a field or executing a query.noreply@blogger.com (kate putin)What are Packages
Sun, 27 Jul 2008 09:03:00 +0000A PACKAGE is a PL/SQL object that groups PL/SQL types, variables, SQL cursors, exceptions, procedures, and functions.Each package has a specification and a body. The specification shows the object you can access when you use the package. The body fully defines all the objects and can contain additional objects used only for the internal workings. You can change the body (for example, by adding procedures to the packages) without invalidating any object that uses the package.noreply@blogger.com (kate putin)What are Triggers
Sun, 27 Jul 2008 09:03:00 +0000automatically executes on one or more specified events (BEFORE or AFTER an INSERT, UPDATE or DELETE) affecting the table. Triggers can execute for the table as a whole or for each affected row in the table.noreply@blogger.com (kate putin)What are Snapshots
Sun, 27 Jul 2008 09:02:00 +0000A SNAPSHOT is a means of creating a local copy of remote data. A snapshot can be used to replicate all or part of a single table, or to replicate the result of a query against multiple tables. The refreshes of the replicated data can be done automatically by the database or manually.noreply@blogger.com (kate putin)
Isolated, non isolated and cascade
feedcat.net promotes your content, measures audiences
and saving load of your server resources!
*