update_rows

Updates rows in a global or central table.

Available in a network database and requires the star$modify role.

Parameters:

Name	Optional	Type	Description
table$	Mandatory	Text	Name of table to be updated
columns$	Mandatory	Text	List of columns to be updated
values$	Mandatory	Text	List of expressions to update columns with
where$	Mandatory	Text	Where clause to identify rows to be updated

Examples:

SELECT update_rows('mytable','col1,col2','col1+1,2','col2<>2'); -- updates rows in 'mytable';

Tips:

• The star$tables view lists existing tables and their scope.