to WangMinYI(步行者)你这样的写法。我举个例子。 现有一数据库1000条记录。我想中间500(有可能是任意数)往前取数据,每次取出10条。现假设分页标记为500那么用 select top 10 from jbxx where cbh<500 是把最前面的1到10给显示出来了。 我想应该取的是490-500之间的数, 再点击上一页时显示480-490
Identifies a record in a dataset for later navigation.UnitDBtype TBook = Pointer;DescriptionTBook is the type of the Book parameter in the GetBook, GotoBook, and FreeBook methods of a dataset component. Note: Different types of datsets can implement books differently. Do not use a TBook from one type of dataset (for example, a BDE-enabled dataset) with methods on another type of dataset (for example, an ADO-based dataset). 在你500处放一个标签;BOOKMARK;
form jbxx
where cbh<分页标记
select top 10
from jbxx
where cbh<500
是把最前面的1到10给显示出来了。
我想应该取的是490-500之间的数, 再点击上一页时显示480-490
在你500处放一个标签;BOOKMARK;
select top 10
就可以了。
select top 10 ...
就可以啦