• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13.  Recordset Objects > The GetRows Method

The GetRows Method

You can use the GetRows( ) recordset method to transfer all or some of a recordset’s resultset to a two-dimensional field. In the process, the system uses the GetRows( ) parameter to pass the number of rows to be included in the array. If the number exceeds the number of records in the recordset, the array dimensions are modified accordingly. Use UBound(var,2) + 1 to specify the number of rows that are actually transmitted. You must pass the number of dimensions as a second parameter to the array so that the UBound( ) function returns the correct number of rows in the two-dimensional array. In the following example, the conDimension constant executes this process.

The following is the general definition for GetRows( ):


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint