Action Statements

Change the position of a column/row in a table object.

change {row ROWNUM|column COL_ID} of TABLE_NAME position

{by OFFSET|to {POSITION|beginning|end}

#OR#

{after|before} {row ROWNUM|column COL_ID} }

ROWNUM

The number of a row.

COL_ID

The identifier (name or number) of a column.

TABLE_NAME

The identifier for a table.

by OFFSET

A positive or negative integer representing the number of columns/rows by which you want to move the specified column/row.

to POSITION | beginning | end

Move the column/row to a specific POSITION in the table, or to the table's beginning (before the current column/row 1) or end (after the last column/row). Specify POSITION as a positive integer.

Description

Use this statement to move a row or column to a different position in a table. The parent of the table may not be temporary and invisible when you issue this statement or it will be ignored.

Example

 

if (InputOK_BV) then

 copy "change column " X_IV " of Table" to MsgStr_SV

 append " position to " Y_IV to MsgStr_SV

 action SendMsg

 change column X_IV of Table_TBL position to Y_IV

end if # InputOK

See Also

column modifiability of Built-in Function

position Keyword