insert_rows

Inserts rows into a global or central table.

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

Parameters:

 

Name Optional Type Description
table$ Mandatory Text The table to insert rows into.
columns$ Mandatory Text List of columns to be populated.
rows$ Mandatory Text Values to be inserted.

Examples: 

SELECT insert_rows('mytable','col1,col2','(1,2)'); -- inserts one row into table mytable

SELECT insert_rows('mytable','col1,col2','(1,2),(3,4)'); -- inserts two rows into table mytable

Tips:

  • The star$tables lists existing tables and their scope

 

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk