Creating a recordset 1

[paultervit]

I'm trying to create a recordset, not associated with any database. Is this possible. I want to create a recordset that will be filled from an array I have created. I guess I need to define the columns etc. Is this possible.

Thanks

Paul

 

[CasperTFG]

Absolutley... You can look up Disconnected Recordset in MSDN.

Here is a start though. Reference ADO in your project.
[tt]
Public Function CreateEmptyRecordSet() as ADODB.Recordset
Dim rs as ADODB.Recordset
Set rs = New ADODB.Recordset

With rs
.Fields.Append "ID", adInteger, , adFldKeyColumn
.Fields.Append "Name", adVarWChar, 32, adFldIsNullable
.Open
End With
Set CreateEmptyRecordSet = rs
Set rs = Nothing
End Function
[/tt]

Craig, mailto:sander@cogeco.ca

In the computer industry, there are three kinds of lies:
lies, damn lies, and benchmarks.

 

[mshetti]

Dear paultervit

Yes I think this is possible, please read some help for creating recordset. At now I do'nt have any code and will take some time to write this. I will paste it here tomorrow.

Best Regards
Mahesh

 

[paultervit]

Thnaks for the help I have got this working now