我找到了“快乐的戏子”写的,在他的基础上修改了以下, http://blog.csdn.net/cnhgj/archive/2004/11/05/169395.aspx他的 下一页 判断不对 我做了一下修改 totalput := RecordSet.RecordCount; if Page = 0 then Page := 1; if (page-1)*page_size > totalput then begin if (totalPut mod page_size)=0 then page := totalPut div page_size else page := totalPut div page_size + 1; end;
select top 10 * from table WHERE id not in (select top 10*页数-1 ID from table)
http://blog.csdn.net/cnhgj/archive/2004/11/05/169395.aspx他的 下一页 判断不对 我做了一下修改 totalput := RecordSet.RecordCount;
if Page = 0 then Page := 1;
if (page-1)*page_size > totalput then
begin
if (totalPut mod page_size)=0 then
page := totalPut div page_size
else
page := totalPut div page_size + 1;
end;