TupleRowToItem

From Planimate Knowledge Base
Revision as of 14:58, 8 January 2009 by Jay.Lange (talk | contribs)
Jump to navigation Jump to search

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.