指定资料录集是唯读或仅能附加的。
指定资料录集资料行的栏位资料成员。
编辑缓冲区包含新的资料录。
资料录集物件让您可存取所有选取的资料录。
A recordset object gives you access to all the selected records.
本主题说明如何在一个资料录集内执行交易。
This topic explains how to perform a transaction in a recordset.
您在资料录集更新时的角色和架构所提供的功能。
Your role in recordset updating and what the framework does for you.
当您需要同时更新多重资料录时,交易尤其有用。
Transactions are particularly useful when you have multiple records that must be updated simultaneously.
资料录集是编辑缓冲区和 动态集和快照集间的差异性。
The recordset as an edit buffer and the differences between dynasets and snapshots.
巡览资料录集时,您通常需要一个返回特定资料录的方法。
When navigating through a recordset, you often need a way of returning to a particular record.
使用包含大量资料录的资料录集填入控制项时要特别小心。
Take precautions against trying to fill a control from a recordset with a large number of records.
另外RFX还可将资料由您的资料录集传送至资料来源。
RFX additionally transfers data from your recordset to the data source.
资料录集类别内对应的栏位资料成员或参数资料成员之名称。
The name of the corresponding field data member or parameter data member in the recordset class.
您可根据一或多个资料行,依照递增或递减顺序来排序资料录。
You can sort the records in ascending or descending order, based on one or more columns.
您可筛选资料录以便从可用的资料录中条件约束要选取的资料录。
You can filter the records to constrain which records are selected from those available.
否则,目前资料录指标就会设定为筛选后集合检视的第一个资料录。
Otherwise, the current record pointer is set to the first record of the filtered collection view.
本主题说明如何筛选资料录集,以便其仅选取可用资料录的特定子集。
This topic explains how to filter a recordset so that it selects only a particular subset of the available records.
资料录集物件在相同时间内只能表示一笔选取的资料录,即目前资料录。
At the same time, a recordset object represents only one of the selected records, the current record.
在ODBC方面,驱动程序会维持资料指标来追踪在资料录集中的位置。
In ODBC terms, a driver maintains a cursor to keep track of its position in the recordset.
当您尝试再次更新该资料录时,资料来源可能会因为不相符而不允许更新。
When you try to update the record again, the data source might disallow the update because of the mismatch.
排序会将目前资料录指标保留在上次选取的记录上,但集合检视已经重组。
Sorting preserves the current record pointer on the last record selected, but the collection view is restructured around it.
您可限制所使用的资料录数目,以筛选条件和排序资料行来取得汇总结果。
You can limit the number of records you use to obtain aggregate results by filtering and sorting the columns.
若要了解两者间的差异,请参阅资料录集:撷取大量资料录(ODBC)。
To understand the differences, see Recordset: Fetching Records in Bulk (ODBC).
如果您需要进一步了解rfx,请参阅资料录栏位交换:RFX的运作方式。
If you need a more advanced understanding of RFX, see Record Field Exchange: How RFX Works.
若要移至特定资料录,在巡览列文字方块中输入列号,然后按下ENTER。
To go to a particular record, type the number of the row in the text box in the navigation bar and then press ENTER.
RF x会在新增一笔资料录和编辑一笔已存在的资料录前先备份编辑缓冲区。
RFX backs up the edit buffer before adding a new record and before editing an existing record.
当架构将它附加至资料录集的SQL陈述式时,where子句便会限制选取。
When the framework appends it to the recordset's SQL statement, the WHERE clause constrains the selection.
请注意,移动目前资料录指标,会与套用到集合的任何排序或筛选有某些互动。
Note that moving the current record pointer has some interactions with any sorting or filtering that is applied to the collection.
一旦超过最后一笔资料录,接下来的10笔资料录就会从资料来源撷取至快取。
As soon as you move past the last record, the next 10 records are fetched from the data source into the cache.
在真正的联结中,资料录是从父和子资料表取得,然后放入单一的一般资料录集。
In a true join, records are taken from parent and child tables and put into a single, flat recordset.
当使用者卷动至一笔新资料录时,架构会使用栏位资料成员来表示目前的资料录。
As the user scrolls to a new record, the framework USES the field data members to represent the current record.
应用推荐