Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Next Record in a View
Message
De
02/09/1998 10:07:01
 
 
À
02/09/1998 08:45:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00132291
Message ID:
00132335
Vues:
12
>I have a view of remote data that contains one record (the table is to large to download all of it locally each time). How do I requery the view to go to the next record (or previous) record. The primary key is sequential but records can be deleted so the primary key could be 1,2,3,99,203, etc. I thought about taking the current record's primary key and then in a loop add 1 to it until a record is found but this does not seem very efficient. I would appreciate any help.

An idea: use a second view, which selects MIN(primarykey) WHERE primarykey>yourcurrentkey, and then requery the first using the key you got from the second view.

HTH!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform