|
<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Methods > <ADODB_Recordset>.GetRows |
Description
Retrieves multiple records of a Recordset object into an array
Syntax
<ADODB_Recordset>.GetRows(StringArray)
Returns
None.
Parameters
Name |
Type |
Optional |
Meaning |
StringArray |
String |
No |
A string array |
Remarks
Use the GetRows method to copy records from a Recordset into a two-dimensional array.
The first subscript identifies the field and the second identifies the record number.
The StringArray variable is automatically dimensioned to the correct size when the GetRows method returns the data.
Note: To improve speed it is advisable to open the recordset with a client-side cursor and a set forward only records type.
Restrictions
Previous data present in StringArray variable will be deleted
See also
Examples