|
|
 |
Syntax
Table.bulkUpdate(tablename,
fields, filter[, doScripts])
| Arguments |
Description |
| tablename |
Specify the
data table on which to perform the query. |
| fields |
The fields
argument contains data that will be inserted
into the specified table. fields refers to
an object, object literal, or a string in
the form of URL filter syntax. |
| filter |
Specify a
portion of the data table to update using a
filter. |
| doScripts |
If doScripts
is TRUE,
the scripts associated with the table's OnUpdate
function will run on the rows modified. If
FALSE
the table's scripts are not called. |
|
Returns
The number of records updated.
Description
Updates every record that matches the specified filter with the data contained in the fields argument. If any update fails, they all fail and an exception will be thrown.
The user must have 'Edit records' permission or greater, i.e. the role of 'Editor' or above, as listed in the security tab to execute a bulkUpdate() method call. Users with the role of 'Author' or below are not able to successfully call bulkUpdate().
Example
var num = Table.bulkUpdate("AddressBook",
{Zip:"98105-6001"}, "Address1='DataWeb Corporation'", false);
//'num' is a number equivalent to the number of records updated
//by the bulkUpdate.
Related Topics
Table Object,
Table.update(),
Table.bulkDelete()
|
