TupleRowToItem: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
An item has the following attributes (only): | An item has the following attributes (only): | ||
''i.ID = 1111 | ''i.ID ''= 1111 | ||
''i.Colour = Blue | ''i.Colour ''= Blue | ||
''i.Size = Large | ''i.Size ''= Large | ||
A table named ''Location ''exists as follows: | A table named ''Location ''exists as follows: | ||
| Line 40: | Line 40: | ||
|} | |} | ||
<br>Applying the Routine Operation '''TupleRowToItem((t.location.Row(2))''' | |||
Applying the Routine Operation '''TupleRowToItem((t.location.Row(2))''' | |||
Would '''''set''''' the item attributes to the following values: | Would '''''set''''' the item attributes to the following values: | ||
Revision as of 15:58, 8 January 2009
Operation
For the specified row, the operation will set item attributes that have the same name as the column names of the specified table.
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 TupleRowToItem((t.location.Row(2))
Would set the item attributes to the following values:
i.ID = 3523
i.Colour = Green
Note:
- i.Size remains unchanged as it doesn't appear as a column in the table.
- i.Location doesn't exist so it is not set.