dim Number as integer dim sql as string dim RsTemp as new adodb.recordsetcnndb为数据库连接 sql="select * from tabm order by cid" RsTemp.open sql,cnndb,xxx,xxx number=400 do while not rstemp.eof and Number>0 if Number-RsTemp!jp>0 then Number=Number-RsTemp!jp RsTemp!jp=0 else RsTemp!jp=RsTemp!jp-Number exit do end if RsTemp.MoveNext Loop就是你想要的结果
dim sql as string
dim RsTemp as new adodb.recordsetcnndb为数据库连接
sql="select * from tabm order by cid"
RsTemp.open sql,cnndb,xxx,xxx
number=400
do while not rstemp.eof and Number>0
if Number-RsTemp!jp>0 then
Number=Number-RsTemp!jp
RsTemp!jp=0
else
RsTemp!jp=RsTemp!jp-Number
exit do
end if
RsTemp.MoveNext
Loop就是你想要的结果