📄 tclientdataset的使用技巧.mht
字号:
pm.DataType:=3DftString;<BR> =20
ClientDataSet1.Params.Clear;<BR> =20
ClientDataSet1.Params.AddParam(pm);<BR> =20
=
ClientDataSet1.Params.ParamByName('dd').AsString:=3Dedit1.Text=20
;<BR> ClientDataSet1.Open;<BR> =
=20
pm.Free;<BR> =
end;<BR><BR>9.=CA=FD=BE=DD=B5=C4=B8=FC=D0=C2=B9=DC=C0=ED<BR> =20
(1)savepoint =
=B1=A3=B4=E6=C4=BF=C7=B0=CE=AA=D6=B9=CA=FD=BE=DD=D7=B4=CC=AC=A3=AC=BF=C9=D2=
=D4=BB=D6=B8=B4=B5=BD=D5=E2=B8=F6=D7=B4=CC=AC<BR> var<BR> =
=20
pp:integer;<BR> begin<BR> =20
pp:=3DClientDataSet1.SavePoint;<BR> =20
ClientDataSet1.Edit;<BR> =20
=
ClientDataSet1.FieldByName('=D0=D5=C3=FB').asstring:=3D'=B9=C5=BB=B0=
';<BR> =20
ClientDataSet1.Post;<BR> =20
table1.Refresh;<BR> end;<BR> =
=BB=D6=B8=B4=B5=E3<BR> =20
ClientDataSet1.SavePoint:=3Dpp;<BR> =20
=A3=A82=A3=A9cancel,RevertRecord<BR> =20
=
=C8=A1=CF=FB=B6=D4=B5=B1=C7=B0=BC=C7=C2=BC=B5=C4=D0=DE=B8=C4=A3=AC=D6=
=BB=CA=CA=BA=CF=C3=BB=D3=D0post=B5=C4=A3=AC=C8=E7=B9=FBpost=A3=AC=B5=F7=D3=
=C3<BR> =20
RevertRecord<BR> (3)cancelupdate<BR> =
=20
=
=C8=A1=CF=FB=B6=D4=CA=FD=BE=DD=BF=E2=CB=F9=D3=D0=B5=C4=D0=DE=B8=C4<BR>&nb=
sp;=20
=A3=A84=A3=A9UndoLastChange(boolean),changecount<BR> =
=20
=
=C8=A1=CF=FB=C9=CF=D2=BB=B4=CE=B5=C4=D0=DE=B8=C4=A3=AC=BF=C9=D2=D4=CA=B5=CF=
=D6=C1=AC=D0=F8=B3=B7=CF=FB<BR> =
=B2=CE=CA=FD=CE=AAtrue:=B9=E2=B1=EA=B5=BD=BB=D6=B8=B4=B4=A6<BR> =
=20
=
false:=B9=E2=B1=EA=D4=DA=B5=B1=C7=B0=CE=BB=D6=C3=B2=BB=B6=AF<BR> =20
=
changecount=B7=B5=BB=D8=D0=DE=B8=C4=BC=C7=C2=BC=B5=C4=B4=CE=CA=FD=A3=
=AC=D2=BB=B8=F6=BC=C7=C2=BC=D0=DE=B8=C4=B6=E0=B4=CE=A3=AC=B7=B5=BB=D8=D6=BB=
=D2=BB=B4=CE<BR> =20
=
=B5=ABUndoLastChange=D6=BB=B3=B7=CF=FB=D2=BB=B4=CE<BR> =
<BR>10.=BF=C9=D0=B4=B5=C4recno<BR> =20
=
=B6=D4=D3=DATtable=BA=CDTquery=B5=C4recno=CA=C7=D6=BB=B6=C1=B5=C4=A3=
=AC=B6=F8TClientDataSet=B5=C4recno=BF=C9=B6=C1=BF=C9=D0=B4<BR> =20
=
ClientDataSet1.recno:=3D5;=CA=C7=C9=E8=B5=DA=CE=E5=B8=F6=BC=C7=C2=BC=
=CE=AA=B5=B1=C7=B0=BC=C7=C2=BC<BR>11.=CA=FD=BE=DD=B1=A3=B4=E6<BR> =20
=
=B6=D4=D3=DAtable=CA=B9=D3=C3post=BF=C9=B8=FC=D0=C2=CA=FD=BE=DD<BR> =
=20
=
=B6=F8ClientDataSet1=B5=C4post=D6=BB=B8=FC=D0=C2=C4=DA=B4=E6=CA=FD=BE=DD=A3=
=AC=D2=AA=B8=FC=D0=C2=B7=FE=CE=F1=C6=F7=CA=FD=BE=DD=D2=AA=CA=B9=D3=C3<BR>=
=20
ApplyUpdates=A3=A8MaxErrors: =
Integer),=CB=FB=D3=D0=D2=BB=B8=F6=B2=CE=CA=FD=A3=AC=CA=C7=D4=CA=D0=ED=B7=A2=
=B3=F6=B4=ED=CE=F3=B5=C4<BR> =20
=
=B4=CE=CA=FD,-1=B1=ED=CA=BE=CE=DE=CA=FD=B4=CE,=CA=B9=D3=C3simpleobjectbro=
ker=CA=B1=B3=A3=C9=E8=CE=AA0=A3=AC=CA=B5=CF=D6=D7=D4=B6=AF=C8=DD=B4=ED=BA=
=CD=B8=BA=D4=D8=C6=BD=BA=E2 <IMG height=3D1=20
src=3D"http://www.pcbookcn.com/down_info.asp?id=3D3679" =
width=3D1=20
border=3D0></SPAN><BR><BR><FONT=20
=
color=3D#666666>[=CE=C4=D5=C2=C2=BC=C8=EB=D4=B1:nancy]</FONT></TD></TR>
<TR>
<TD width=3D"100%" bgColor=3D#cccccc =
height=3D1></TD></TR></TBODY></TABLE><BR>
<TABLE cellSpacing=3D2 cellPadding=3D2 width=3D"96%">
<TBODY>
<TR>
<TD vAlign=3Dtop width=3D"50%" =
height=3D"100%"><B>=CF=E0=B9=D8=CE=C4=D5=C2</B>=A3=BA<FONT=20
face=3D"Arial, Helvetica, sans-serif"></FONT> </TD>
<TD vAlign=3Dtop width=3D"50%" =
height=3D"100%"><B>=CF=E0=B9=D8=C8=ED=BC=FE</B>: <FONT=20
face=3D"Arial, Helvetica, =
sans-serif"></FONT></TD></TR></TBODY></TABLE></DIV></TD>
<TD vAlign=3Dtop align=3Dleft width=3D180=20
background=3Dhttp://www.pcbookcn.com/images/right_bottom0.gif=20
bgColor=3D#ffffff><DIV align=3Dleft>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D176 =
bgColor=3D#ffffff border=3D0>
<TBODY>
<TR>
<TD =
background=3Dhttp://www.pcbookcn.com/images/right_empty.gif=20
height=3D32>
<DIV class=3DSTYLE3=20
align=3Dcenter>::PCBOOKCN'ADS::</DIV></TD></TR></TBODY></TABLE>
<SCRIPT language=3DJavaScript =
src=3D"http://www.pcbookcn.com/js/ads_a2.js">
</SCRIPT>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D180 border=3D0>
<TBODY>
<TR>
<TD style=3D"LINE-HEIGHT: 20px" align=3Dmiddle =
bgColor=3D#ffffff><IMG=20
height=3D6 =
src=3D"http://www.pcbookcn.com/images/right_top.gif"=20
width=3D180></TD></TR>
<TR>
<TD align=3Dmiddle=20
=
background=3Dhttp://www.pcbookcn.com/images/right_bottom0.gif></TD></TR>
<TR>
<TD style=3D"LINE-HEIGHT: 20px" align=3Dmiddle =
bgColor=3D#ffffff=20
height=3D8><IMG height=3D8=20
src=3D"http://www.pcbookcn.com/images/right_bottom.gif"=20
width=3D180></TD></TR></TBODY></TABLE>
<TABLE height=3D32 cellSpacing=3D0 cellPadding=3D0 width=3D176 =
bgColor=3D#ffffff=20
border=3D0>
<TBODY>
<TR>
<TD =
background=3Dhttp://www.pcbookcn.com/images/right_empty.gif=20
height=3D32>
<DIV align=3Dcenter><SPAN=20
=
class=3DSTYLE3>::=C6=E4=CB=FC::</SPAN></DIV></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D180 border=3D0>
<TBODY>
<TR>
<TD style=3D"LINE-HEIGHT: 20px" align=3Dmiddle =
bgColor=3D#ffffff><IMG=20
height=3D6 =
src=3D"http://www.pcbookcn.com/images/right_top.gif"=20
width=3D180></TD></TR>
<TR>
<TD style=3D"LINE-HEIGHT: 25px" align=3Dleft=20
background=3Dhttp://www.pcbookcn.com/images/right_bottom0.gif>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D171 =
border=3D0>
<TBODY>
<TR>
<TD width=3D4></TD>
<TD class=3Dleft_bgline style=3D"LINE-HEIGHT: 25px"=20
align=3Dmiddle><SPAN style=3D"LINE-HEIGHT: 25px"><A=20
href=3D"http://www.pcbookcn.com/article/49_1.htm"=20
target=3D_blank><FONT =
color=3D#000000>ACCESS</FONT></A><BR><A=20
href=3D"http://www.pcbookcn.com/article/50_1.htm"=20
target=3D_blank><FONT color=3D#000000>MS =
SQL</FONT></A><BR><A=20
href=3D"http://www.pcbookcn.com/article/51_1.htm"=20
target=3D_blank><FONT =
color=3D#000000>MySQL</FONT></A><BR><A=20
href=3D"http://www.pcbookcn.com/article/52_1.htm"=20
target=3D_blank><FONT =
color=3D#000000>Oracle</FONT></A><BR><A=20
href=3D"http://www.pcbookcn.com/article/53_1.htm"=20
target=3D_blank><FONT =
color=3D#000000>Foxpro</FONT></A><BR><A=20
href=3D"http://www.pcbookcn.com/article/54_1.htm"=20
target=3D_blank><FONT=20
color=3D#000000>PowerBuilder</FONT></A><BR><A=20
href=3D"http://www.pcbookcn.com/article/55_1.htm"=20
target=3D_blank><FONT =
color=3D#000000>Sybase</FONT></A><BR><A=20
href=3D"http://www.pcbookcn.com/article/56_1.htm"=20
target=3D_blank><FONT=20
=
color=3D#000000>=C6=E4=CB=FC</FONT></A><BR></SPAN></TD></TR></TBODY></TAB=
LE></TD></TR>
<TR>
<TD style=3D"LINE-HEIGHT: 20px" align=3Dmiddle =
bgColor=3D#ffffff=20
height=3D8><IMG height=3D8=20
src=3D"http://www.pcbookcn.com/images/right_bottom.gif"=20
width=3D180></TD></TR></TBODY></TABLE>
<TABLE height=3D32 cellSpacing=3D0 cellPadding=3D0 width=3D176 =
bgColor=3D#ffffff=20
border=3D0>
<TBODY>
<TR>
<TD =
background=3Dhttp://www.pcbookcn.com/images/right_empty.gif>
<DIV class=3DSTYLE3 =
align=3Dcenter>::=D4=C4=B6=C1=C5=C5=D0=D0::</DIV></TD></TR></TBODY></TABL=
E>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D180 border=3D0>
<TBODY>
<TR>
<TD style=3D"LINE-HEIGHT: 20px" align=3Dmiddle =
bgColor=3D#ffffff><IMG=20
height=3D6 =
src=3D"http://www.pcbookcn.com/images/right_top.gif"=20
width=3D180></TD></TR>
<TR>
<TD align=3Dleft=20
background=3Dhttp://www.pcbookcn.com/images/right_bottom0.gif>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D171 =
border=3D0>
<TBODY>
<TR>
<TD width=3D4></TD>
<TD class=3Dleft_bgline style=3D"LINE-HEIGHT: =
25px">=A1=A4<A=20
=
title=3DASP=D3=EB=CA=FD=BE=DD=BF=E2=D3=A6=D3=C3(=C8=EB=C3=C5=BD=CC=B3=CC)=
=20
href=3D"http://www.pcbookcn.com/article/2017.htm"=20
=
target=3D_blank>ASP=D3=EB=CA=FD=BE=DD=BF=E2=D3=A6=D3=C3(=C8=EB=C3=C5=BD=CC=
=B3=CC)</A><BR>=A1=A4<A =
title=3D=D2=EC=B9=B9=CA=FD=BE=DD=BF=E2=D6=AE=BC=E4=B5=C4=B5=BC=C8=EB=B5=BC=
=B3=F6=CA=BE=C0=FD=20
href=3D"http://www.pcbookcn.com/article/1171.htm"=20
=
target=3D_blank>=D2=EC=B9=B9=CA=FD=BE=DD=BF=E2=D6=AE=BC=E4=B5=C4=B5=BC=C8=
=EB=B5=BC=B3=F6=CA=BE=C0=FD</A><BR>=A1=A4<A=20
title=3DTClientDataSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9=20
href=3D"http://www.pcbookcn.com/article/3679.htm"=20
=
target=3D_blank>TClientDataSet=B5=C4=CA=B9...</A><BR></TD></TR></TBODY></=
TABLE></TD></TR></TBODY></TABLE>
<SCRIPT language=3DJavaScript =
src=3D"http://www.pcbookcn.com/js/ads_a2b.js">
</SCRIPT>
</DIV></TD></TR>
<TR>
<TD bgColor=3D#ffffff></TD>
<TD vAlign=3Dtop align=3Dleft bgColor=3D#ffffff><SPAN=20
style=3D"LINE-HEIGHT: 20px"><IMG height=3D8=20
src=3D"http://www.pcbookcn.com/images/right_bottom.gif"=20
width=3D180></SPAN></TD></TR></TBODY></TABLE>
<TABLE height=3D5 cellSpacing=3D0 cellPadding=3D0 width=3D760 =
align=3Dcenter border=3D0>
<TBODY>
<TR>
<TD background=3Dhttp://www.pcbookcn.com/images/bottom_fenge1.gif=20
height=3D5></TD></TR></TBODY></TABLE>
<TABLE class=3Dfonts height=3D93 cellSpacing=3D0 cellPadding=3D0 =
width=3D760 align=3Dcenter=20
background=3Dhttp://www.pcbookcn.com/images/bottom1.gif border=3D0>
<TBODY>
<TR>
<TD align=3Dmiddle>
<SCRIPT language=3DJavaScript=20
src=3D"http://www.pcbookcn.com/js/bottom.js"></SCRIPT>
</TD></TR></TBODY></TABLE><!-- =
=D6=D0=BB=AA=B5=E7=C4=D4=CA=E9=BF=E2-=B5=E7=D7=D3=CD=BC=CA=E9,=B5=E7=C4=D4=
=CA=E9=BC=AE,=B5=E7=C4=D4=BD=CC=D1=A7, =
=B5=E7=C4=D4=BD=CC=B3=CC,=B5=E7=C4=D4=CE=C4=D5=AA,=D4=C4=B6=C1TClientData=
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -