使用记录集对象进行查询和更新。
通过数据库类,可以使用记录集对象来选择和访问结果集。
With the database classes, you use a recordset object to select and access the result set.
在服务器端,使用记录集的pagesize属性将搜索结果分割成区块,以限制在浏览器中同时显示的结果数。
On the server side, you use the PageSize property of the recordset to split the search results into chunks to limit the number of results displayed simultaneously in the browser.
使用这些命令能够让报表分成多个相关记录集,使报表更可读和有序。
Using them allows reports to be broken down into multiple sets of related records, making a report more readable and sorted.
如果需要根据某个特定的列值将报表分成多个记录集,那么您可以使用BREAK命令。
If a report needs to be broken into separate sets of records based on a particular column value, then you can use the BREAK command.
然后,使用此记录集迭代遍历搜索结果以显示给定的子集。
This recordset is then used to iterate through the search results to display a given subset.
记录集对象使用完毕后,请关闭并且销毁它。
When you finish using the recordset object, you close and destroy it.
反过来,记录集使用记录字段交换(RFX)在它的字段数据成员和数据源上表中相应的列之间移动数据。
The recordset, in turn, USES record field exchange (RFX) to move data between its field data members and the corresponding columns in a table on the data source.
联接操作(一个通用的数据访问任务)使您得以使用一个记录集对象处理来自多个表的数据。
The join operation, a common data-access task, lets you work with data from more than one table using a single recordset object.
当定义一个记录集类时,需要指定与之相关的数据源、要使用的表和表的列。
When you define a recordset class, you specify the data source to associate it with, the table to use, and the columns of the table.
基本方法是使用记录视图显示(可能的话还要更新)单个记录集的记录。
The basic approach is to use the record view to display and perhaps update the records of a single recordset.
你可以通过使用这个方法来创建多个记录集的复版,特别是当你希望编辑多个记录时。
You can use this method to create multiple, duplicate Recordset, particularly if you want to edit more than one current record in a set of records.
您也可以使用它来提供易于使用的ADO记录集浏览的用户界面与绝对最低限度的代码。
You can also use it to provide an easy to use ADO recordset browsing UI with absolutely minimal code.
当使用向导创建表的记录集时(设计时),可以选择要在记录集中出现的表列。
When you use a wizard to create a recordset for a table (at design time), you can choose which columns of the table to represent in the recordset.
注意:书签属性仅可以在支持书签属性的记录集对象中使用。
Note: The bookmark property is available only in Recordset objects that support bookmarks.
注意:书签属性仅可以在支持书签属性的记录集对象中使用。
Note: The bookmark property is available only in Recordset objects that support bookmarks.
应用推荐