ADO RecordSet Process - Revision history

Water at 19:04, 27 February 2016

2016-02-27T19:04:01Z

← Older revision		Revision as of 19:04, 27 February 2016
Line 1:		Line 1:
	~~{{WIP}}~~
	= Search/process the fetched data =		= Search/process the fetched data =
	== Access ==		== Access ==

Rt01: /* Access */

2014-01-17T10:43:06Z

Access

← Older revision		Revision as of 10:43, 17 January 2014
Line 3:		Line 3:
	== Access ==		== Access ==
	'''GetRows'''<br />		'''GetRows'''<br />
	The '''GetRows method''' is used to copy records from a Recordset object into ~~a variant that is~~ a two-dimensional array. The ~~variant~~ array is automatically dimensioned (sized) to fit the requested number of columns and rows. To allow backwards compatibility with earlier versions of ADO, the columns are placed in the first dimension of the array and the rows are placed in the second dimension.		The '''GetRows method''' is used to copy records from a Recordset object into a two-dimensional array. The array is automatically dimensioned (sized) to fit the requested number of columns and rows. To allow backwards compatibility with earlier versions of ADO, the columns are placed in the first dimension of the array and the rows are placed in the second dimension.

	In comparison, the similar GetString method returns a specified Recordset as a string.		In comparison, the similar GetString method returns a specified Recordset as a string.

Rt01: /* Access */

2014-01-12T23:21:00Z

Access

← Older revision		Revision as of 23:21, 12 January 2014
Line 40:		Line 40:
	The optional '''StringFormat''' parameter is one of the StringFormatEnum constants that define the format to be used when converting the Recordset object to a string.		The optional '''StringFormat''' parameter is one of the StringFormatEnum constants that define the format to be used when converting the Recordset object to a string.

	~~As of ADO version 2~~.~~5, the~~ StringFormatEnum ~~Constants consists only of the Default value~~ adClipString (2). Delimits columns ~~using the~~ ColumnDelimiter ~~parameter, delimits rows using the RowDelimiter parameter~~, ~~sets a substitute for Null using the~~ NullExpr ~~parameter.~~		Possible values for the [http://msdn.microsoft.com/en-us/library/windows/desktop/ms675298%28v=vs.85%29.aspx StringFormatEnum] enumeration are:
			{\| class="wikitable"
			\|-
			! Constant !! Value !! Description
			\|-
			\| adClipString \|\| 2 \|\| (Default) Delimits rows by RowDelimiter, columns by ColumnDelimiter, and null values by NullExpr
			\|}

	The optional '''NumRows''' parameter is a long value that specifies how many records in the Recordset to convert to a string. If left blank, the default is to do all of the records. If NumRows exceeds the actual number of available records, only the actual number will be returned and no error will be generated.		The optional '''NumRows''' parameter is a long value that specifies how many records in the Recordset to convert to a string. If left blank, the default is to do all of the records. If NumRows exceeds the actual number of available records, only the actual number will be returned and no error will be generated.

Rt01: /* Search */

2014-01-12T23:18:14Z

← Older revision		Revision as of 23:18, 12 January 2014
Line 84:		Line 84:
	The optional '''SearchDirection''' parameter is one of the SearchDirectionEnum constants that specify which direction the search should proceed, either forward or backward. If no matching record is found for a forward search, the record pointer is set at EOF. If no matching record is found for a backward search, the record pointer is set at BOF.		The optional '''SearchDirection''' parameter is one of the SearchDirectionEnum constants that specify which direction the search should proceed, either forward or backward. If no matching record is found for a forward search, the record pointer is set at EOF. If no matching record is found for a backward search, the record pointer is set at BOF.

	SearchDirectionEnum ~~Constants~~:		Possible values for the [http://msdn.microsoft.com/en-us/library/windows/desktop/ms676696%28v=vs.85%29.aspx SearchDirectionEnum] enumeration are:
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-
Line 96:		Line 96:
	The optional '''Start''' parameter is a variant that is either a bookmark or one of the BookmarkEnum constants that indicates the starting position for the search. The default is to start at the current record.		The optional '''Start''' parameter is a variant that is either a bookmark or one of the BookmarkEnum constants that indicates the starting position for the search. The default is to start at the current record.

	BookmarkEnum ~~Constants~~:		Possible values for the [http://msdn.microsoft.com/en-us/library/windows/desktop/ms676118%28v=vs.85%29.aspx BookmarkEnum] enumeration are:
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-

Rt01: /* Access */

2014-01-12T23:16:18Z

Access

← Older revision		Revision as of 23:16, 12 January 2014
Line 14:		Line 14:
	The optional '''Rows''' parameter is one of the GetRowsOptionEnum constants which specify how many records to retrieve. Even if you request more records than are available in the Recordset, only the actual number of records will be returned and no error will be generated. The default is to select all records starting from the current record.		The optional '''Rows''' parameter is one of the GetRowsOptionEnum constants which specify how many records to retrieve. Even if you request more records than are available in the Recordset, only the actual number of records will be returned and no error will be generated. The default is to select all records starting from the current record.

	GetRowsOptionEnum ~~Constants~~:		Possible values for the [http://msdn.microsoft.com/en-us/library/windows/desktop/ms677558%28v=vs.85%29.aspx GetRowsOptionEnum] enumeration are:
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-

Rt01 at 22:59, 12 January 2014

2014-01-12T22:59:24Z

← Older revision		Revision as of 22:59, 12 January 2014
Line 1:		Line 1:
	{{{WIP}}}		{{WIP}}
	= Search/process the fetched data =		= Search/process the fetched data =
	== Access ==		== Access ==

Rt01 at 22:58, 12 January 2014

2014-01-12T22:58:36Z

← Older revision		Revision as of 22:58, 12 January 2014
Line 1:		Line 1:
			{{{WIP}}}
	= Search/process the fetched data =		= Search/process the fetched data =
	== Access ==		== Access ==

Rt01: /* Access */

2014-01-12T22:57:30Z

Access

@@ Line 33: / Line 33: @@
 Syntax:
   string = recordsetobject.GetString (StringFormat, NumRows, ColumnDelimiter, RowDelimiter, NullExpr)
-In comparison, the similar GetRows method returns a variant that is a two-dimensional array
+In comparison, the similar GetRows method returns a variant that is a two-dimensional array containing selected records from a Recordset object.
 containing selected records from a Recordset object.
 There are five optional parameters.

Rt01: /* Access */

2014-01-12T22:51:57Z

Access

@@ Line 5: / Line 5: @@
 In comparison, the similar GetString method returns a specified Recordset as a string.
 There are three optional parameters.
@@ Line 26: / Line 29: @@
 '''GetString'''<br />
-Returns the specified Recordset as a string.
+The '''GetString method''' returns a specified Recordset object as a string.

Rt01: /* Search */

2014-01-12T22:49:09Z

← Older revision		Revision as of 22:49, 12 January 2014
Line 41:		Line 41:

	Syntax:		Syntax:
	~~array =~~ recordsetobject.Find(Criteria, SkipRecords, SearchDirection, Start)		recordsetobject.Find(Criteria, SkipRecords, SearchDirection, Start)

	There is one mandatory and three optional parameters.		There is one mandatory and three optional parameters.