w3schools    w3Schools
Search :
   
HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...   References Examples Forum About
ADVERTISEMENTS

XML Certification
Download XML editor
Custom Programming
 
Table of contents
ADO Tutorial
ADO HOME
ADO Intro
ADO Connect
ADO Recordset
ADO Display
ADO Query
ADO Sort
ADO Add
ADO Update
ADO Delete
ADO Demo
ADO Speed Up

ADO Objects
ADO Command
ADO Connection
ADO Error
ADO Field
ADO Parameter
ADO Property
ADO Record
ADO Recordset
ADO Stream
ADO DataTypes

ADO Summary

Examples
ADO Examples

Exam
ADO Exam

Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality

Browse Tutorials
 

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