Synopsis:

       adoRSetAddNew(handle)

Arguments:

       handle - The recordset handle.

Description:   This function attempts to add a new record to a recordset as specified by handle.

Use the adoRSetSupports() function with adAddNew (a CursorOptionEnum value) to verify whether you can add records to the current recordset object.

After you call the adoRSetAddNew() function, the new record becomes the current record and remains current after you call the adoRSetUpdate() function.    Since the new record is appended to the recordset, a call to adoRSetMoveNext() following the update will move past the end of the recordset, making EOF True.    If the recordset object does not support bookmarks, you may not be able to access the new record once you move to another record.  Depending on your cursor type, you may need to call the adoRSetRequery() method to make the new record accessible.

If you call adoRSetAddNew() while editing the current record or while adding a new record, ADO calls the underlying Update method automatically in this case to save any changes and then creates the new record.

Returns:   Returns 0 upon success or a negative error code.   If ADOERR_COMERR is returned, then the underlying ADO error can be obtained by calling adoLastError()