Please note, this is a STATIC archive of website www.w3schools.com from 05 May 2020, cach3.com does not collect or store any user information, there is no "phishing" involved.
THE WORLD'S LARGEST WEB DEVELOPER SITE

ADO AddNew Method


❮ 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
%>

❮ Complete Recordset Object Reference