Oracle Returns Error When Adding Record To Recordset With ADO

[Quoted] I am using an ADO object to select records from a table and it works fine.

However, in the next line of the program I try to add a new record as follows:

RSSales.AddNew Array("sym", "name"), Array("TEST", "TESTCO")

[Quoted] When I run the program, the select works fine and then I get the following error when it tries to add the record to the recordset:

"The operation requested by the application is not supported by the provider."

Please explain what I am doing wrong.

Thanks in advance. Received on Sun Aug 27 2000 - 00:41:47 CEST