Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing
Message
 
 
To
26/06/2009 08:55:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01408583
Message ID:
01408623
Views:
80
>>Here's my take on it
>>
>>lnFirst = 32000
>>lnPageSize = 25
>>lnStart = thisform.txtStart.Value
>>
>>thisform.txtPageno.Value = CEILING((lnStart - lnFirst + 1) / lnPageSize )	
>>
>
>You were close:) I like Ceiling() and use it more in fact too:
>
>
thisform.txtPageno.Value = CEILING((m.lnStart - m.lnFirst) / m.lnPageSize )
>

There's discrepancy in the original data. On one hand record numbers start from 32000. On other hand the first page starts with record # 32001. There's no need to change the formula, only lnFirst has to be adjusted.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform