W3Schools.com

ADO AddNew Method


Recordset Object Reference Complete Recordset Object Reference

The AddNew method creates a new record for an updateable Recordset object.

After you call this method, the new record will be the current record. 

Syntax

objRecordset.AddNew fieldlist,values

Parameter Description
fieldlist Optional. A field name, or an array of field names, or the numeric position of the fields in the new record
values Optional. A value, or an array of values for the fields in the new record

Example

<%
rs.AddNew "ProductName","Chang"
%>

or

<%
varfields=Array("ProductName","Prize","Quantity")
varvalues=Array("Chang","19","24-12 oz bottles")
rs.AddNew varfields,varvalues
%>


Recordset Object Reference Complete Recordset Object Reference
WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Best Hosting Coupons
UK Reseller Hosting
Cloud Hosting
Top Web Hosting
$7.95/mo SEO Hosting
Premium Website Design
WEB BUILDING
Download XML Editor
FREE Website BUILDER
Free Website Templates Free CSS Templates
Make Your Own Website
W3SCHOOLS EXAMS
Get Certified in:
HTML, CSS, JavaScript, XML, PHP, and ASP
W3SCHOOLS BOOKS
New Books:
HTML, CSS
JavaScript, and Ajax
STATISTICS
Browser Statistics
Browser OS
Browser Display
SHARE THIS PAGE