recordset.addnew

I am trying to add a new record to an odbc data base. I am
using MS ActiveX library2.8. The syntax is recordset.AddNew
(object fieldlist, object values). Object fieldlist and
values can be one field/value or can be an array of fields
and values. My problem is I do not know how to set up the
array for this to work. I try the following: string[] fn
= new string[]={"Name_of_the_field", "Name_of_the_field"};
string[] fv=new string[] = {"Value_of_the_field",
Value_of_the_field"};
recordset.Open
(query,connection,ADODB.CursorTypeEmun.adOpenKeyse t,ADODB.L
ockTypeEnum.adLockOptimistic,-1);
recordset.AddNew(fn, fv); I get the following error: Item
can not be found in colletion corresponding to the
requested name or ordinal.

[Frank Oquendo]

an*******@discussions.microsoft.com wrote:

I am trying to add a new record to an odbc data base. I am
using MS ActiveX library2.8.

Why that and not ADO.NET?

--
There are 10 kinds of people. Those who understand binary and those who
don't.

http://code.acadx.com
(Pull the pin to reply)