Populate the DOCollection with a subset of the search results
generated using the specified SQLBuilder.
| C# | Visual Basic | Visual C++ |
public void FindRange( int startIndex, int endIndex, SQLBuilder sqlObj )
Public Sub FindRange ( _ startIndex As Integer, _ endIndex As Integer, _ sqlObj As SQLBuilder _ )
public: void FindRange( int startIndex, int endIndex, SQLBuilder^ sqlObj )
- startIndex (Int32)
- The index of the first row to be retrieved. Must be >=0 and <= the row count of the results.
- endIndex (Int32)
- The index of the final row to be retrieved.
- sqlObj (SQLBuilder)
This will retrieve the first 50 rows in the result set:
Dim sColl as New StudentCollection Dim mySql as SQLBuilder = sColl.GetSqlBuilder() mySql.addWhere(Student.Columns.Name, name) sColl.FindRange(0, 49, mySql)