ADO » Recordset » AddNew
- Syntax:
- recordsetobject.AddNew FieldList, Values
- Values
- The optional Values parameter is a single value or an array of values for the fields that you want to populate in the new record. If the FieldList parameter is an array, then Values must also be an array. Further, Values must have the exact same number of members and be in the same order as FieldList.
- FieldList
- The optional FieldList parameter is a variant that can be a single field name, or an array of field names, or the numeric (ordinal) position of the fields in the new record. For both the single name and array of names, each name must be enclosed within a pair of double quotes. Multiple names in the array must be separated (delimited) by commas.
Used to create a new record.
The AddNew method is called to create and initialize a new record that can be added to an
updateable Recordset.
The provider must support adding new records.
There are two optional parameters.
Since the parameters are optional, there are two ways to use the AddNew method, with
or without the arguments.
If you do not use parameters, then you will need to call the Update or UpdateBatch
methods.
When you use the optional parameters, ADO will automatically perform the update.
However, if you are doing batch updates, you will still need to call the UpdateBatch method.
Examples
Code:
MyObject.AddNew "FirstName", "Sasha"
Code:
MyObject.AddNew Array("FirstName", "LastName"), Array("Luke", "Skywalker")
Code:
varFieldList = Array("FirstName", "LastName")
varValues = Array("Luke", "Skywalker")
MyObject.AddNew varFieldList, varValues
Code:
strFirstName = "The"
strLastName = "Guru"
intAge = 826
...
rsGuruData.AddNew
rsGuruData.Fields("FirstName") = strFirstName
rsGuruData.Fields("LastName") = strLastName
rsGuruData.Fields("Age") = intAge
rsGuruData.Update
See Also:
