Home
Search
 
What's New
Index
Books
Links
Q & A
Newsletter
Banners
 
Feedback
Tip Jar
 
C# Helper...
 
XML RSS Feed
Follow VBHelper on Twitter
 
 
 
MSDN Visual Basic Community
 
 
 
 
 
TitleMake a class that manages arrays retrieved by calling Recordset.GetRows
Description
KeywordsRecordset, GetRows, array
CategoriesDatabase
 
Thanks to dooris_jo@willis.com.

A call to a Recordset's GetRows method returns a two-dimensional array. The first dimension gives the number of fields and the second gives the records.

This class provides a set of functions for manipulating this kind of array. The functions include:

FunctionPurpose
AreAnyOfTheseInThisLook for records containing certain values
AreAnyOfTheseNOTInThisLook for records not containing certain values
RemoveRecordRemove a record from the array
AddRecordsAdd records to the array
GetARecordRetrieve a record by index
GetRecordsByFieldValueReturn an array containing matching records
IsThisRecordADuplicateReturn True if a specific record is present in the array
AppendFieldAdd a field to each record in the array
ConvertFieldDataToTypeConvert a field in the array to a specified data type (string, integer, or date)
SaveArraySave the array in a file
RemoveFieldsRemove fields from the array
StripDupesRemove adjacent duplicate records

 
 
Copyright © 1997-2010 Rocky Mountain Computer Consulting, Inc.   All rights reserved.
  Updated