TupleItemToRow: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
== Operation == | == Operation == | ||
The operation will '''''set''''' cells in the specified row to the item attribute vaules where the column name has the same name as the item attribute. | |||
Note: | Note: | ||
| Line 7: | Line 7: | ||
*Numerical values will be set regardless of the formatting of the columns (cells) or item attributes. | *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. | *Matching item attribute and column names are NOT case sensitive. | ||
== Example == | == Example == | ||
Revision as of 16:01, 8 January 2009
Operation
The operation will set cells in the specified 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.
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 TupleItemToRow((t.Location.Row(2))
Would set the second row values to the following values:
| ID | Name | Colour | Location |
| 2345 | Turner | Red | Hobart |
| 1111 | Lisbon | Blue | Brighton |
Note:
- Column Location and Name remains unchanged as there is no item attributes called Location nor Name.