Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleted records and a scrollbar
Message
From
03/06/2005 11:44:42
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01019811
Message ID:
01019938
Views:
19
>Hi everybody,
>
>If I delete records from the cursor which is source for the grid, the scrollbar now has a gap and could not be put at the top. Is there a way to fix this behavior or there is no way (as I found with filters)...
>
>What should I answer to the user who noticed this problem?
>
>Thanks in advance.

Nadya,
the solution it is simple.

VFP uses RECNO()/RECCOUNT() when compute the scrollbar gap.

When a index is active, it uses the index keyPos/keysCount.

Then active a filtered index with FOR NOT DELETED() condition
( on VFP9 this optimize se SET DELETED ON filter also )
* on a cursor with none indexes, active this ( or faster idx )
INDEX ON .T. FOR NOT DELETED() TAG TDEL
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform