Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VCR buttons
Message
 
 
To
27/05/2003 14:32:42
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00793208
Message ID:
00793229
Views:
23
>Hi All,
>I seem to remember a trick when using a VCR button setup to scroll thru a set of records. A person doesn't use skip, but something else. I think it had something to do with the recno() in the cursor/table. Does anyone know?
>Thanks,

You can do this with RECNO() under two conditions:
1. Table/cursor is viewed in natural (RECNO()) order
2. There's no deleted records and no filter set
First - GOTO 1
Prev - RECNO() > 1 THEN GOTO (RECNO()-1)
NEXT - RECNO()<RECCOUNT() THEN GOTO (RECNO()+1)
LAST - GOTO (RECCOUNT())
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform