While searching for a reply to my own question (asked a few minutes ago), I came across several references to this GetRows method. What is it and how does one use it. If it does what I think, I have many instances where I can use it in place of what I'm currently using.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
GetRows method
- Thread starter Zygor
- Start date
GetRows is a method of a DAO or ADODB RecordSet that returns a variant holding a two dimensional array with columns in 1st dimension and rows in 2nd.
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
fredericofonseca
IS-IT--Management
Dim recArray As Variant
Dim rst As New ADODB.Recordset
recArray = rst.GetRows
'Note: GetRows returns a 0-based array where the first
'dimension contains fields and the second dimension
'contains records.
Hitting F1 on the getrows will give you a application called HELP. This should be used whenever possible.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
Dim rst As New ADODB.Recordset
recArray = rst.GetRows
'Note: GetRows returns a 0-based array where the first
'dimension contains fields and the second dimension
'contains records.
Hitting F1 on the getrows will give you a application called HELP. This should be used whenever possible.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question