ADO Recordset error when appending fields
Posted on 2010-09-08
After googling and searching EE for a solution, I finally admit that I need help from you guys (and girls).
I need to append fields to a closed Recordset. It should be easy enough:
ADODB.Recordset rs = new ADODB.Recordset();
rs.Fields.Append("My columne name", ADODB.DataTypeEnum.adDouble, 0, ADODB.FieldAttributeEnum.adFldIsNullable, null);
But then I get this error in the second line:
Message=Error: Missing method 'instance void [MyClass] ADODB.Fields::Append(string,valuetype ADODB.DataTypeEnum,int32,valuetype ADODB.FieldAttributeEnum,object)' from class 'ADODB.InternalFields'.
I have checked the specifications of the Append-method, and itseems that I am using it correctly.
Still, I hope some of you might tell me what's wrong, so that I can correct my code ASAP :)
Looking forward to your replies.