Hi All,
The Spreadtable Administration details are following:-
Oracle forms use Spreadtable to display and format dynamically retrieved data at runtime using bean area container. This is accomplished by predefined metadata which drives what data has to be retrieved and presented at runtime.
The Spreadtable Administration details are following:-
Oracle forms use Spreadtable to display and format dynamically retrieved data at runtime using bean area container. This is accomplished by predefined metadata which drives what data has to be retrieved and presented at runtime.
Use the SpreadTable Meta Data Administration window to design SpreadTables that plug into an Oracle Forms bean area container.
Perform the following steps to create a new spreadtable.
1. Navigate to SpreadTable Administration screen.
The Spreadtable Meta Data Administration window opens.
2. Define a new datasource (a set of metadata) by entering the following:
o Datasource Name: The unique name that identifies a set a metadata. It must always be_.
o Application: The name of your product.
o Title: A descriptive name for this set of metadata.
o Relational View Name: Select from the LOVs the name of the view from which information is to be retrieved to populate the spreadtable.
o Lines/Rows: Enter how many lines of text are to display per row.
o WHERE Clause: (Optional) Enter a SQL statement here if desired. Use this field to enter filtering criteria. NEVER start with the keyword WHERE, as this is automatically prepended to the statement. Always use bindvariables if the value changes at runtime.
3. Select the Database tab, if it is not already selected, and enter the following for each column that you wish to display in the spreadtable:
o Column Alias: The column alias becomes part of the primary key, therefore it must be a unique name. For example, the names, "currency" and "currency_code" will generate an error stating there is an ambiguous column in SELECT list. Column alias names cannot contain SQL reserved words or an error generates stating the keyword was not found where expected.
o View Column/ Function: Select from the LOVs the desired name of the View Column.
o Datatype: Select from the LOVs either character, number, or date.
o Query Sequence: The sequence value determines the order in which columns are extracted from the database. You could start with 1, but in actual practice, it is a good idea to leave gaps in the sequence for ease of row insertion later. To improve performance, begin with the columns that you will refer to in your code, typically the primary key columns to execute a query in a detail block.
o Sortable: Selecting this box allows the user to sort on this column.
o Default Sort Order: Sort in ascending or descending default order.
4. Select the Display tab, and enter the following for each column that you defined previously:
o Visible: Select to make this column visible in the spreadtable.
o Freeze Visible Property: Select if you want the end user to be able to change the visible properties (show/hide) at run time for this column.
o Display Sequence: The value determines the order in which the columns display in the spreadtable.
o Display Width: Sets the width (in pixels) of the displayed column. This value depends on the data that is displayed in the column.
o The Column Alias and Label fields are supplied automatically. However, you may change these values, if desired.
5. Select the Alignment and Formatting tab, and enter the following:
o Header Alignment: Select from the LOVs either Center, End, Right, or Start.
o Cell Alignment: Select from the LOVs either Center, End, Right, or Start.
o Display Type: Select from the LOVs either check box, Hyperlink, or Text.
o Display Format: (Optional) Select from the LOVs either Currency, Date, or Date Time.
6. Select the Custom Format Masks and Mappings tab.
o Column Alias: The column alias field is filled automatically.
o Check box Mappings: These options apply only if the display type field in the Alignments and Formatting tab is set to check box.
§ Checked: Sets whether or not a column value is represented as a checked check box or as its corresponding image.
§ Unchecked: Sets whether or not a column value is represented as an unchecked check box or as its corresponding image.
§ Other: Sets how values other than those specified as either checked or unchecked are represented.
o Format Mask: Use to set how columns with datatype Number display data. For example, it would display the values as a percent. Use this only in rare cases.
o Currency Column: Points to the database view column where the currency code for the current column is stored. This applies only if the display format is set to Currency.
7. Select the Sort Order tab, and perform the following:
o Choose the Primary Sort key from the LOVs.
o You can optionally select a second or third Sort key from the LOV.
8. Click the Save icon on the toolbar. (The icon looks like a floppy disk.)
9. Select the Test tab, and click Test.
Sanjay
1. Navigate to SpreadTable Administration screen.
The Spreadtable Meta Data Administration window opens.
2. Define a new datasource (a set of metadata) by entering the following:
o Datasource Name: The unique name that identifies a set a metadata. It must always be
o Application: The name of your product.
o Title: A descriptive name for this set of metadata.
o Relational View Name: Select from the LOVs the name of the view from which information is to be retrieved to populate the spreadtable.
o Lines/Rows: Enter how many lines of text are to display per row.
o WHERE Clause: (Optional) Enter a SQL statement here if desired. Use this field to enter filtering criteria. NEVER start with the keyword WHERE, as this is automatically prepended to the statement. Always use bindvariables if the value changes at runtime.
3. Select the Database tab, if it is not already selected, and enter the following for each column that you wish to display in the spreadtable:
o Column Alias: The column alias becomes part of the primary key, therefore it must be a unique name. For example, the names, "currency" and "currency_code" will generate an error stating there is an ambiguous column in SELECT list. Column alias names cannot contain SQL reserved words or an error generates stating the keyword was not found where expected.
o View Column/ Function: Select from the LOVs the desired name of the View Column.
o Datatype: Select from the LOVs either character, number, or date.
o Query Sequence: The sequence value determines the order in which columns are extracted from the database. You could start with 1, but in actual practice, it is a good idea to leave gaps in the sequence for ease of row insertion later. To improve performance, begin with the columns that you will refer to in your code, typically the primary key columns to execute a query in a detail block.
o Sortable: Selecting this box allows the user to sort on this column.
o Default Sort Order: Sort in ascending or descending default order.
4. Select the Display tab, and enter the following for each column that you defined previously:
o Visible: Select to make this column visible in the spreadtable.
o Freeze Visible Property: Select if you want the end user to be able to change the visible properties (show/hide) at run time for this column.
o Display Sequence: The value determines the order in which the columns display in the spreadtable.
o Display Width: Sets the width (in pixels) of the displayed column. This value depends on the data that is displayed in the column.
o The Column Alias and Label fields are supplied automatically. However, you may change these values, if desired.
5. Select the Alignment and Formatting tab, and enter the following:
o Header Alignment: Select from the LOVs either Center, End, Right, or Start.
o Cell Alignment: Select from the LOVs either Center, End, Right, or Start.
o Display Type: Select from the LOVs either check box, Hyperlink, or Text.
o Display Format: (Optional) Select from the LOVs either Currency, Date, or Date Time.
6. Select the Custom Format Masks and Mappings tab.
o Column Alias: The column alias field is filled automatically.
o Check box Mappings: These options apply only if the display type field in the Alignments and Formatting tab is set to check box.
§ Checked: Sets whether or not a column value is represented as a checked check box or as its corresponding image.
§ Unchecked: Sets whether or not a column value is represented as an unchecked check box or as its corresponding image.
§ Other: Sets how values other than those specified as either checked or unchecked are represented.
o Format Mask: Use to set how columns with datatype Number display data. For example, it would display the values as a percent. Use this only in rare cases.
o Currency Column: Points to the database view column where the currency code for the current column is stored. This applies only if the display format is set to Currency.
7. Select the Sort Order tab, and perform the following:
o Choose the Primary Sort key from the LOVs.
o You can optionally select a second or third Sort key from the LOV.
8. Click the Save icon on the toolbar. (The icon looks like a floppy disk.)
9. Select the Test tab, and click Test.
Sanjay
