Copying columns between tables in a routine: Difference between revisions
Jump to navigation
Jump to search
m (1 revision(s)) |
mNo edit summary |
||
| Line 1: | Line 1: | ||
The [[Routine Operations#InsertCol|InsertCol routine operation]] accepts a "Column" reference which can be a column for a different table. | |||
In that case, the column is copied (with formatted) and resized to the appropriate number of rows and inserted into the target table. | In that case, the column is copied (with formatted) and resized to the appropriate number of rows and inserted into the target table. | ||
This enables copying of formmated columns between tables, use of master formatting tables to dynamically build reports etc. etc. | |||
If the "column" reference is just a scalar number, it copies the indexed column from within the target table. | |||
---- | |||
<font size="2">idkbase note 134</font> | |||
[[Category:Routine]] | [[Category:Routine]] | ||
[[Category:Table | [[Category:Table]] | ||
Latest revision as of 15:07, 12 January 2008
The InsertCol routine operation accepts a "Column" reference which can be a column for a different table.
In that case, the column is copied (with formatted) and resized to the appropriate number of rows and inserted into the target table.
This enables copying of formmated columns between tables, use of master formatting tables to dynamically build reports etc. etc.
If the "column" reference is just a scalar number, it copies the indexed column from within the target table.
idkbase note 134