Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you use skip and other record related commands with
Message
De
13/06/2006 16:27:30
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
13/06/2006 11:32:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Database:
Visual FoxPro
Divers
Thread ID:
01127886
Message ID:
01128831
Vues:
27
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform