Update Records

Data modification can be accomplished by sending the database server an update request. The request should contain the following parameters:

• DataSource : The name of the Database .
• UserName : Your user name for the database.
• Password : Your password. UserName and Password can be omitted if not required by the database.
• TableName : The name of the table where the record is in.
• RowID : The record row id. RowID is always start from 0.
• FieldCount : The number of fields to be updated in the request.
• Field name and value pairs. The information must directly follow the FieldCount in the request.

For example, the following command remove the third record from the customer table in a DBASE file:

http://hostname:port/update?DataSource=TestDbase&TableName=customer&RowID=2&Company="Best Database Service"&Phone="(703)999-9999"


changes the company name and the phone number of the third record in the customer table.

Although you can construct such command manually as the example above, record update can be easily done through Entry Forms where you have retrieved the value of the current record, the field name and value pairs can be added using the INPUT tag in the HTML file. The following is an example how easy it is to create such a form.

Customer Entry Form

[include /include/form.cod]

If you have comments or suggestions, email me at yzhang@erols.com

Send mail to  info2-at-sqldata-dot-com with questions or comments about this web site.
Copyright 2008-2010 SQLData Systems, Inc.
Last modified: July 10, 2010