基于记录集的数据操纵方法研究

Research on Data Manipulation based on Recordset

使用记录集提供的编辑功能方便、高效,但在有些情况下记录集不可编辑。本文分析了记录集可编辑的条件,并给出了在各种情况下通过记录集编辑数据的方法,介绍了基于单一表的R ECORDSET对象基本数据的编辑、基于多个表的R ECORDSET对象基本数据的编辑、关于R ECORDSET对象计算列的编辑处理及关于不支持编辑功能的记录集对象的编辑处理等方法。

The edit function available in the condition of Recordset is very convenient and effective to be performed,but in some eases the Recordset can not be edited. This paper analyzes in what eases the Reeordset is open to be edited and in what case is not. The method of editing data with Recordset in different eases is also presented in this paper. Editing of Recordset object basic data based on single table,editing of Recordset object basic data based on multi tables,and editing processing for Recordset object computing column as well as that of Recordset object which can not support editing function are introduced in this paper.