We have prompt table edit, yes/no table edit, trlate table edit as the table edits.
Using Dosave and Dosavenow functions.
MetaStrings are special type of SQL expressions preceded by % sign.
MetaStrings are used in the following:
Adddropdownitem() Deletedropdownitem()
&Rs.Select or Scrollselect()
Postpones some user actions to reduce the number of trips to the database so that increases the performance (in system edits, field edit, and field change).
Advantages:
Using SQLExec Function
SQLExec (“SELECT EMPLID,NAME FROM PS_PERSONAL_DATA”, &Emplid, &Name);
It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services. In database server we have system tables, peopletools tables and application tables.
In Field edit for each field change, a trition to the application server to the database is taken place. In Saveedit for all the fields , only one trition to the application server to the Database is taken place.
SQLEXEC is used to execute the sql statements(select,insert,update,delete). We can get only one row at a time.
This record field property is used to update the date field of particular record with the server’s current date and time whenever a user creates or updates a row. Even the user enter the data into that field, the data which the user enters will be updated by the system’s current date and time.
Yes we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid. When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid.
Expert entry enables a user to change from interactive to deferred mode at runtime for appropriate tractions
We have field level audit and record level audit.
Primary permission list is used for mass change and definition security purposes.
Search views are used for three main reasons.
To give access to the records that are to be used in query, we have create a new query security tree and add the records which we want to give the access and then assign a access group to the tree. After that we have to add that query tree and query access group to the permission list.
Conditions are:
Advantages are:
The structure of the table in record level audit is: AUDIT_OPRID, AUDIT_STAMP, AUDIT_ACTN, AUDIT_RECNAME and can add fields from record.
You might want to reuse the same component multiple times with different search records. You can accomplish this by overriding the component search record at run-time when the component is opened from a menu item without creating separate copies of the component.
The component override is temporary, and occurs only when the component is opened from the menu item in which the override is set. It does not change the component definition.
Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion.
No we can not hide the primary page of a component. If the component had only one page then by making this page also invisible we wont have any component existing so we are not allowed to hide the primary page.
Component buffer contains all the data of the active component. Data buffer contains the data other than the data in the component buffer (Data of other records)