Column

Goal

Write mask rule logic to

• put values into a table column, taken from another column of the same table.

Ano Structure and Example

Structure

      ...
      mask <column>
          format %s
          column <another-column>
      ...

Update Example

table HOTELROOMCATEGORY
    ...
    column date TODATE
    ...
...
task ... {
    update HOTELROOMCATEGORY
        ...
        mask TODATE             // mask TODATE by setting it equal to FROMDATE
            format %s
            column FROMDATE
        ...
}

Update with Convert Example

table birth_certificate
    ...
      column text personal_number size 11
    ...
...
task ... {
      update birth_certificate
            mask personal_number
                  format "%1$td%1$tm%1$ty12345" // Using date format specifiers requires convert String2Date
                  column birth_date
                        convert String2Date
}

• <column> defined after mask receives the values from another-column defined after column
• Make sure <column> and another-column is in the same table.