Os objetos de Recordset do objeto dos dados de ActiveX (ADO) representam o jogo inteiro dos registros de uma tabela baixa ou dos resultados de um comando executado. Em em qualquer altura que, o objeto de Recordset consulta somente a um �nico registro dentro do jogo como o registro atual.

Usar o objeto de Recordset emitir comandos SELETOS estruturados da l�ngua de pergunta (SQL) nos dobradores.

Por exemplo:

Dim Conn as New ADODB.Connection
Dim Rs as New ADODB.Recordset
Conn.Provider = "ExOLEDB.DataSource"
Conn.Open RootFolderURL

Set Rs.ActiveConnection = Conn
"select ""DAV:displayname"" " _
& "from scope('shallow traversal of ""URL""')" _
& "Where ""DAV:ishidden"" = False"

'...
Conn.Close
Rs.Close
Set Conn = Nothing
Set Rs = Nothing

Os objetos de Recordset do objeto dos dados de ActiveX (ADO) s�o usados manipular dados de um fornecedor. Quando n�s usamos o ADO, n�s manipulamos os dados que usam quase inteiramente objetos de Recordset. Todos os objetos de Recordset consistem em registros (fileiras) e em colunas (campos). Dependendo da sustenta��o funcional pelo fornecedor, algumas m�todos ou propriedades de Recordset n�o podem estar dispon�veis.

Quando n�s abrimos primeiramente um Recordset, o ponteiro de registro atual apontar� ao primeiro registro e as propriedades do BOF e do EOF s�o falsas. Se houver nenhum registro est� atual, o BOF e a propriedade do EOF � verdadeira.

H� o tipo dois de atualizar isso vontade suportada (ADO) por objetos de Recordset:

1: Atualizar imediato

2: Atualizar do grupo

1: Atualizar imediato

Quando voc� chama o m�todo do Update todas as mudan�as est�o escritas imediatamente � base de dados.

2: Atualizar do grupo

O fornecedor cache as mudan�as m�ltiplas e emiti-las-� ent�o ao registro na base de dados com o m�todo de UpdateBatch.

Que � Curser?

Curser � um elemento da base de dados que o updatability dos dados, a navega��o do registro de controles, e a visibilidade das mudan�as fa�am aos therecords na base de dados por outros usu�rios.

H� quatro tipos diferentes do cursor definidos no ADO:

1: Cursor din�mico

2: Cursor do Keyset

3: Cursor de est�tica

4: Cursor Para diante-somente

1: Cursor din�mico

Permite-nos �s adi��es, � vista, �s mudan�as, e aos apagamentos pelos outros usu�rios; permite tamb�m todos os tipos de movimento com o Recordset que n�o confia em bookmarks; e permite bookmarks se o fornecedor os suportar.

2: Cursor do Keyset

Comporta-se como um cursor din�mico, exceto que impede que n�s v os registros que os outros usu�rios adicionam, e impede o acesso aos registros que outros usu�rios suprimem. As mudan�as dos dados por outros usu�rios ser�o ainda vis�veis. Suporta sempre bookmarks e permite conseq�entemente todos os tipos de movimento com o Recordset.

3: Cursor de est�tica

Fornece uma c�pia de est�tica de um jogo dos registros para n�s para usar-se encontrar os dados ou gera-a que relat�rios; permite sempre bookmarks e permite conseq�entemente todos os tipos de movimento com o Recordset. As adi��es, os apagamentos ou as mudan�as por outros usu�rios n�o ser�o vis�veis. Este � o �nico tipo de cursor permitido quando voc� abre um objeto de Recordset do ADO do cliente-lado.

4: Cursor Para diante-somente

Permite que n�s enrolem-se somente para a frente com o Recordset na base de dados. As mudan�as, as adi��es ou os apagamentos por outros usu�rios n�o ser�o vis�veis. Isto melhora o desempenho nas situa��es onde voc� necessita fazer somente uma �nica passagem com um Recordset.

Propriedades do objeto de Recordset do ADO.

Property	Description
AbsolutePage	Sets or returns a value that specifies the page number in the Recordset object
AbsolutePosition	Sets or returns a value that specifies the ordinal position of the current record in the Recordset object
ActiveCommand	Returns the Command object associated with the Recordset
ActiveConnection	Sets or returns a definition for a connection if the connection is closed, or the current Connection object if the connection is open
BOF	Returns true if the current record position is before the first record, otherwise false
Bookmark	Sets or returns a bookmark. The bookmark saves the position of the current record
CacheSize	Sets or returns the number of records that can be cached
CursorLocation	Sets or returns the location of the cursor service
CursorType	Sets or returns the cursor type of a Recordset object
DataMember	Sets or returns the name of the data member that will be retrieved from the object referenced by the DataSource property
DataSource	Specifies an object containing data to be represented as a Recordset object
EditMode	Returns the editing status of the current record
EOF	Returns true if the current record position is after the last record, otherwise false
Filter	Sets or returns a filter for the data in a Recordset object
Index	Sets or returns the name of the current index for a Recordset object
LockType	Sets or returns a value that specifies the type of locking when editing a record in a Recordset
MarshalOptions	Sets or returns a value that specifies which records are to be returned to the server
MaxRecords	Sets or returns the maximum number of records to return to a Recordset object from a query
PageCount	Returns the number of pages with data in a Recordset object
PageSize	Sets or returns the maximum number of records allowed on a single page of a Recordset object
RecordCount	Returns the number of records in a Recordset object
Sort	Sets or returns the field names in the Recordset to sort on
Source	Sets a string value or a Command object reference, or returns a String value that indicates the data source of the Recordset object
State	Returns a value that describes if the Recordset object is open, closed, connecting, executing or retrieving data
Status	Returns the status of the current record with regard to batch updates or other bulk operations
StayInSync	Sets or returns whether the reference to the child records will change when the parent record position changes

M�todos do objeto de Recordset do ADO.

Methods	Description
AddNew	Creates a new record
Cancel	Cancels an execution
CancelBatch	Cancels a batch update
CancelUpdate	Cancels changes made to a record of a Recordset object
Clone	Creates a duplicate of an existing Recordset
Close	Closes a Recordset
CompareBookmarks	Compares two bookmarks
Delete	Deletes a record or a group of records
Find	Searches for a record in a Recordset that satisfies a specified criteria
GetRows	Copies multiple records from a Recordset object into a two-dimensional array
GetString	Returns a Recordset as a string
Move	Moves the record pointer in a Recordset object
MoveFirst	Moves the record pointer to the first record
MoveLast	Moves the record pointer to the last record
MoveNext	Moves the record pointer to the next record
MovePrevious	Moves the record pointer to the previous record
NextRecordset	Clears the current Recordset object and returns the next Recordset object by looping through a series of commands
Open	Opens a database element that gives you access to records in a table, the results of a query, or to a saved Recordset
Requery	Updates the data in a Recordset by re-executing the query that made the original Recordset
Resync	Refreshes the data in the current Recordset from the original database
Save	Saves a Recordset object to a file or a Stream object
Seek	Searches the index of a Recordset to find a record that matches the specified values
Supports	Returns a boolean value that defines whether or not a Recordset object supports a specific type of functionality
Update	Saves all changes made to a single record in a Recordset object
UpdateBatch	Saves all changes in a Recordset to the database. Used when working in batch update mode

Eventos:

Events	Description
EndOfRecordset	Triggered when you try to move to a record after the last record
FetchComplete	Triggered after all records in an asynchronous operation have been fetched
FetchProgress	Triggered periodically in an asynchronous operation, to state how many more records that have been fetched
FieldChangeComplete	Triggered after the value of a Field object change
MoveComplete	Triggered after the current position in the Recordset has changed
RecordChangeComplete	Triggered after a record has changed
RecordsetChangeComplete	Triggered after the Recordset has changed
WillChangeField	Triggered before the value of a Field object change
WillChangeRecord	Triggered before a record change
WillChangeRecordset	Triggered before a Recordset change
WillMove	Triggered before the current position in the Recordset changes