19.4.4 resync 方法.html

javascript即用即差核心对象手册

<script type="text/javascript" src="openConMark.js"></script>
<script type="text/javascript" src="adojavas.inc"> </script>
<script language="javascript">
   var rs1=new ActiveXObject("ADODB.RecordSet");
   var rs2=new ActiveXObject("ADODB.RecordSet");
   rs1.CursorType=rs2.CursorType=adLockOptimistic;
   rs1.LockType=rs2.LockType=adOpenStatic;
   sql="select * from student";
   rs1.Open(sql,objconn);
   rs2.Open(sql,objconn);
   writeRcnt("最初状态：");
   var arr1=new Array("学号","性别","政治面貌","省份");
   var arr2=new Array('01042418','女','团员','山东');   
   rs1.addNew(arr1,arr2);
   rs2.Requery();
   writeRcnt("添加记录之后：");
   arr2[0]='01042419';
   rs1.addNew(arr1,arr2);
   rs2.Resync();
   writeRcnt("添加记录之后：");
   function writeRcnt(str)
   {
       with(document)
	    {
		   write(str+"<br>");
		   write("<li>Rs1中记录数:"+rs1.RecordCount);
		   write("<li>Rs1中记录数:"+rs2.RecordCount);
		   write("<br>");
		}
   }
</script>					
</body>