ADOR.Recordset Object

[Mongoose]

does anyone know why i might be getting this error?

code

m_objRS is of type ADOR.Recordset

m_objRS.AddNew <--ERROR [The operation requested by the application is not supported by the provider]

m_objRS.Fields("ID") = 1
m_objRS.Fields("CEO") = 2

m_objRS.Update

why would that give me an unsuporrted error? if it's not provided then why does the AddNew .. Update procedures exist?

thankx,

[Lothar Haensler]

>why would that give me an unsuporrted error? if it's not provided then why does the AddNew .. Update procedures exist?

AddNew is method of the ADO object model.
ADO simply communicates to the underlying OLEDB providers. If these do not support an ADO method you'll get the error mentioned.
To find out if a recordset supports Addnew, call the Supports function (or property).

[Mongoose]

Thanks for the info.
The Supports( adAddNew ) function is returning FALSE, so I guess it's NOT supported.. :)