|
|
 |
Using the cmdUpdate() object and its associated methods, you can update the records of a data table.
Constructor
| [new] cmdUpdate
(tablename) |
Constructs and returns a new cmdUpdate object. The tablename string argument designates
the table to be updated. |
|
Instance Methods
| execute |
Executes
the update, as specified by the cmdUpdate object's
filter and field settings.
|
| getFields |
Returns the cmdUpdate object's field settings, as specified by the setFields() method. |
| getFilter |
Returns the cmdUpdate object's filter settings, as specified by the setFilter() method. |
| getTablename |
Returns the name of the table specified in the cmdUpdate constructor. |
| setFields |
Specifies the field settings for the cmdUpdate object. |
| setFilter |
Specifies the filter settings for the cmdUpdate object. |
|
Example
The following cmdUpdate example writes the email address "johnsmith@address.com" to each record in the data table "AddressBook" where the LastName field has the value "Smith" and the FirstName field has the value "John".
var upd = new cmdUpdate("AddressBook");
upd.setFilter({LastName:"Smith", FirstName:"John"});
upd.setFields({Email:"JohnSmith@address.com"});
upd.execute();
|
