Search these areas:
Help
Support Forums
Product Info



Introduction
DataWeb: What's New
Creating an Application
The DataWeb Designer
Application Management
Data Tables
Data Tables
Views
Templates
Components
Data Analysis
Members
Security
Importing
Exporting
FTP
JavaScript
Object Model
JavaScript Objects
General Scripting Objects
Data Access Objects
-cmdDelete Object
-cmdInsert Object
-cmdSelect Object
-cmdUpdate Object
execute
getFields
getFilter
getTablename
setFields
setFilter
-Data Access Method Arguments
-Field Object
-Fields Collection
-Index Object
-Indexes Collection
-previous Object
-record Object
-Resultset Object
-Table Object
-Tables Collection
-TextImporter Object
-Settings Object
-View Object
-Web Object
File Access Objects
Http Client Objects
Security and Membership Objects
Document Object Model (DOM)
Error Descriptions
Object Model Extensions
Full-Text Search
Domain and Email Hosting
HotBlock Modules
Account Management
Glossary
New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

DataWeb User's Guide

cmdUpdate Object
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();
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us