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.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk