DevGuru ADO Recordset::AddNew Method

Quick References

Features

Partners



			METHOD: Recordset::AddNew recordsetobject.AddNew FieldList, Values 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. 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. 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. 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. 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