Self-developed blog: http://www.ylhd.com/aa7643/dds_blog/rs.movenext Moves the record pointer down the current location RS.MOVEPREVIOS to move the record pointer from the current position to the row Rs.MoveFirst Recording pointer moves to the data table RS.MOVELAST Move the record pointer to the last line RS.AbsolutePosition = N Move the record pointer to the data table Nth line rs.absolute = n Move the record pointer to the nth page The first line rs.pageSize = N Sets each page for n-record RS.PageCount Returns the total number RS.Recordcount Returns the total number RS.Recordcount Returns the total number of rs.bof Returns the record pointer to be exceeded by the data table, true, FALSE Has RS.eo returns whether the indicator is over the end of the data table, true, whether false is rs.delete deletes the current record, but the record pointer does not move the RS.AddNew to add the RS.AddNEW to the data table RS.Update update data Table Record ------------------------------------------------ -------------- Recordset Object Method Open method RECORDSET.OPEN SOURCE, ACTIVECONNECTION, CURSORTYPE, LOCKTYPE, OptionsSourceRecordset objects can be connected to the Command object via the Source property. The Source parameter can be a COMMAND object name, a SQL command, a specified data table name or a Stored ProCedure. If this parameter is omitted, the system uses the Source property of the Recordset object.
ActiveConnectionRecordset objects can connect the Connection object through the ActiveConnection property. The ActiveConnection here can be a connection object or a string parameter containing database configuration (ConnectionsTRING).
CURSORTYPERECORDSET Object Open method The CURSORTYPE parameter represents what kind of cursor type starts data, including AdopenForwardOnly, AdoPENDYNAMIC, and AdoPenStatic, is described below: ------------------- -------------------------------------------constant?????? ????????????????????????? constant value ?????????????? Description -------- -------------------------------------------------- ---- AdopenForwardonly ???????? 0 ?????????????????????? Default value, start a cursor that can only move forward ( Forward ONLY). AdopenKeyset ?????????????? ???? 1 ???????????????????? Start a KEYSET type cursor. AdoPENDYNAMIC ??????????????????????????????? Start a Dynamic type of cursor. AdoPenStatic ????????????????????????????????? to start a cacope of a Static type. -------------------------------------------------- ------------ The above cursor type will directly affect all the properties and methods of the Recordset object, the following list describes the differences between them.
-------------------------------------------------- ------------ Recordset property adopenkeyset ?? adopenKeyset ?? adopenStatic -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------ AbsolutePage ?????????? does not support support can read and write can read and write AbsolutePosition ?????? no no can read and write can read and write ActiveConnection ???? can read and write can read and write can read and write can read and write BOF ???????? ??????????????? only read only read read only bookmark ?????????????? does not support it does not support readable and write Cachesize? ?????????????? can read and write can read and write CURSORLOCATION ?????? can read and write can read and write can read and write CURSORTYPE ??? ?????????? can read and write readable and write readable and write readable write editmode ???????????????? only read only read only? Read-only EOF? ??????????????????????? only read only read read only Filter ?????????????????? ???? can read and write readable and write readable and write-to-write write locktype ??????????????? can read and write readable write readable and write readable and write MarshalOptions ?????? Readable to read and write readable and write readable, write maxRecords ??????????? can read and write can read and write readable and write read-write PageCount ????????????? Do not support only read-only read-only Pagesize ???????? can read and write readable and write readable and write read / write RecordCount ???????? does not support Read only Source ??????????????????? can read and write readable and write readable and write read / write State ????????????? ???????? only read only read read only STATUS ???????????????????? only read only read read only AddNew ???? ?????????? Support support support CancelBatc h ????????? Support support support CancelupDate ??????? Support support support Clone ???????????????????? does not support Close ???????????????????? support support support support DELETE ???????????????????? Support support support GetRows ?? ????????????? Support support support MOVE ??????????????????? does not support support support MOVEFIRST ????????? ??? Support support support MoveLast ???????????? does not support support support MOVENEXT ??????????? Support support support MOVEPREVIOUS ??????? Support support support NEXTRECORDSET ?????? Support support support open ???????????????????? support support support Requuery ???????????????????????? ????? Support Support Support RESYNC ????????? does not support support support supports ????????????? Support support support Update ???????? support support support support UPDATEBATCH ??????? Support support support ------------- -------------------------------------------------among them NextRecordset methods do not apply to the Microsoft Access database.
