如记录集:
rst.open "select * from book", cn, adOpenStatic, adLockOptimistic
如何通过记录集rst,求得这个记录集中字段A的值总和。请不要回答:
rst.open "select sum(A) as A from book", cn, adOpenStatic, adLockOptimistic
rst.open "select * from book", cn, adOpenStatic, adLockOptimistic
如何通过记录集rst,求得这个记录集中字段A的值总和。请不要回答:
rst.open "select sum(A) as A from book", cn, adOpenStatic, adLockOptimistic
变量=0
rst.movefirst 记录移至第一条
while not rst.eof do
begin
变量=变量+rst.fields['a'].value 变量加字段A的值
rst.movenext 记录移到下一条
end
整个rst的记录数完,变量的值就是总和