M MingWord Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-17 #1 在查询分析器中,如果使用Update语句执行结果可以得知更新了多少条语句,在DELPHI中,如何取得这个值?
X xeen Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-17 #2 var iAffectCount:Integer; begin ADOCommand1.CommandText := 'update tab set F_ID = F_ID + 1'; ADOCommand1.Execute(iAffectCount,EmptyParam);
var iAffectCount:Integer; begin ADOCommand1.CommandText := 'update tab set F_ID = F_ID + 1'; ADOCommand1.Execute(iAffectCount,EmptyParam);
G gxgyj Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-20 #6 if adoquery1.execsql=0 then showmessage('零')
M MingWord Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-21 #7 不用存储过程怎么办?我只是在DELPHI中用执行SQL语句.
L lfzxs Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-23 #9 先Select一下,再Update 如: Select Count(FID) From TabName where FId > 10 Update TabName set FName = 'ACC' where FID > 10
先Select一下,再Update 如: Select Count(FID) From TabName where FId > 10 Update TabName set FName = 'ACC' where FID > 10
