Make a recordset without a connection
Hi,
Why are you using adIUnknown datatype? adIUnknown is a pointer to interface
of COM objetc and is not what you need in your case. All your steps are
correct except datatype. Specify explicit one, like adVarChar and it should
work fine
.Fields.Append "POS", adIVarChar, 3
......
--
Val Mazur
Microsoft MVP
Quote:
> Hi.
> Is there a way to make a recordset and fill this with
> values without having a connection?
> I tried this:
> Dim rsttempstk As ADODB.Recordset
> Set rsttempstk = New ADODB.Recordset
> With rsttempstk
> .Fields.Append "POS", adIUnknown
> .Fields.Append "AANTAL", adIUnknown
> .Fields.Append "CHILD", adIUnknown
> .Supports (adAddNew)
> .Open
> .AddNew
> !Pos = "001"
> !aantal = "1"
> !Child = "123456789"
> End With
> This gives the error : Multiple-step operation generates
> errors:
> Geert