TupleItemToRow: Difference between revisions
Jump to navigation
Jump to search
(New page: == Operation == For the specified row, the operation will '''''set''''' cells in the row to the item attributes vaules provided the column name has the same name as the item attribute. ...) |
No edit summary |
||
| Line 22: | Line 22: | ||
A table named ''Location'' exists as follows: | A table named ''Location'' exists as follows: | ||
{| cellspacing="1" cellpadding="1" width=" | {| cellspacing="1" cellpadding="1" width="250" border="1" | ||
|- | |- | ||
| '''''ID''''' | | '''''ID''''' | ||
| Line 48: | Line 48: | ||
Would '''''set'''''the second row values to the following values: | Would '''''set'''''the second row values to the following values: | ||
{| cellspacing="1" cellpadding="1" width=" | {| cellspacing="1" cellpadding="1" width="250" border="1" | ||
|- | |- | ||
| '''''ID''''' | | '''''ID''''' | ||
Revision as of 15:50, 8 January 2009
Operation
For the specified row, the operation will set cells in the row to the item attributes vaules provided 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 setthe 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.