Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you use skip and other record related commands with
Message
From
13/06/2006 16:27:30
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
13/06/2006 11:32:02
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01127886
Message ID:
01128831
Views:
22
>I have designed the class so that it retrives only one record ata time from the source in xml format.
>whenever the next, previous , first or last function is called depending on the keyfield only one record
>is retrived and the cursor for this single is created and attached to cursor adapter.
>
>What I want is when SKIP command is issued on this cursor it should call a cursoradapter function to get
>the record.

Hi Rajesh,

The Xbase Skip, Scan...EndScan, etc. commands work on a _FoxPro_ cursor, whether it's a Fox table, a view, or a cursor generated by a Cursor Adapter. You can't, however, use these commands on the back end database. You can only exectue SQL commands that retrieve rows based on some criteria.

What web developers who have massive amounts of data do is to retrieve a group of rows at a time and let you navigate through those. Notice how a Google search works - you get 10 (or whatever) results per page (that you can scroll up and down in your browser) and you have the opportunity to get the next 10 results or go back to the previous 10 results.

Try designing your app to get groups of rows. If you show the group of rows in a grid the user can easily navigate them. Then use a button of some sort to get the next or previous group.
Previous
Reply
Map
View

Click here to load this message in the networking platform