ADO: AddNew Method

ADO: AddNew Method

rs.AddNew "ProductName","Chang"

or

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



Code (VBScript):
MyObject.AddNew "FirstName", "Sasha"

Or

MyObject.AddNew Array("FirstName", "LastName"), Array("Luke", "Skywalker")

Or

varFieldList = Array("FirstName", "LastName")
varValues = Array("Luke", "Skywalker")
MyObject.AddNew varFieldList, varValues

Or

strFirstName = "The"
strLastName = "Guru"
intAge = 826
...
rsGuruData.AddNew
rsGuruData.Fields("FirstName") = strFirstName
rsGuruData.Fields("LastName") = strLastName
rsGuruData.Fields("Age") = intAge
rsGuruData.Update

Complete Recordset Object Reference