TupleAppendFromItem: Difference between revisions
Jump to navigation
Jump to search
(New page: == Operation == The operation will '''''append''''' a row at the end of the table and '''''set''''' cells in that row to the item attribute vaules where the column na...) |
Peter.Page (talk | contribs) No edit summary |
||
Line 23: | Line 23: | ||
A table named ''Location'' exists as follows: | A table named ''Location'' exists as follows: | ||
{| cellspacing="1" cellpadding="1" | {| cellspacing="1" cellpadding="1" border="1" width="250" | ||
|- | |- | ||
| '''''ID''''' | | '''''ID''''' | ||
Line 45: | Line 45: | ||
Will '''''append''''' a row and '''''set''''' the new (last) row values to the following: | Will '''''append''''' a row and '''''set''''' the new (last) row values to the following: | ||
{| cellspacing="1" cellpadding="1" | {| cellspacing="1" cellpadding="1" border="1" width="250" | ||
|- | |- | ||
| '''''ID''''' | | '''''ID''''' | ||
Line 72: | Line 72: | ||
Note: | Note: | ||
*''Column Location and Name'' will be set to the default column values as there | *''Column Location and Name'' will be set to the default column values as there are no item attributes called ''Location'' or ''Name''. <br> |
Latest revision as of 08:56, 20 February 2009
Operation
The operation will append a row at the end of the table and set cells in that row to the item attribute vaules where the column name has the same name as the item attribute.
Note:
- Numerical values will be set regardless of the formatting of the columns (cells) or item attributes.
- Matching item attribute and column names are NOT case sensitive.
- Columns that do not have a tuple match will contain the colunms default value.
Report Tuple Deails when pressed with load the default text reader and report the item attributes (by class if there are more than one item flow through the routine) that match the column names of the specified table.
Example
An item has the following attributes (only):
i.ID = 1111
i.Colour = Blue
i.Size = Large
A table named Location exists as follows:
ID | Name | Colour | Location |
2345 | Turner | Red | Hobart |
3523 | Lisbon | Green | Brighton |
Applying the Routine Operation TupleAppendFromItem((t.Location)
Will append a row and set the new (last) row values to the following:
ID | Name | Colour | Location |
2345 | Turner | Red | Hobart |
3523 | Lisbon | Green | Brighton |
1111 | {Default} | Blue | {Default} |
Note:
- Column Location and Name will be set to the default column values as there are no item attributes called Location or Name.