set_column_value

Declaration

set_column_value (name: STRING; index: INTEGER; value: STRING)

Description

Sets the value of column name in the item at index in the current query to value. The column name cannot be empty and the index must exist with the current query.

See Also

database functions
Database

Example

script mark_questions_as_closed is
  reset_column_search_strings
  set_column_search_string ('type', 'question')
  i := 0
  while i < total_items loop
    set_column_value ('status', i, 'closed')
  end
end