Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Landing on a particular record in a view
Message
De
29/07/1999 12:28:26
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00247717
Message ID:
00247750
Vues:
31
Do you want to return to a specific record, whenever you see a specific set of records?
If so, perhaps you need an EnableMoveToLast property and a MoveToLast method.
In your Requery you can check for the EnableMoveToLast, and if it's true run the MoveToLast(). Also whenever you move the pointer in this record group, you will need to store the KeyValue.
Something like this.
PROCEDURE Park
oApp.SetSettings(This.ParentKeyValue, "KeyValue", This.RefName, m.KeyValue)
RETURN

PROCEDURE MoveToLast			
WhereToGo = oApp.GetSettings(This.ParentKeyValue, "KeyValue", This.RefName)
IF NOT ISNULL(m.WhereToGo)
   SELECT (This.Alias)
   KeyField = This.KeyField
   LOCATE FOR &KeyField. = m.WhereToGo
   IF FOUND(This.Alias)
   ELSE
      * You never know if the record will still be there.
      GO TOP IN (This.Alias)
   ENDIF
ENDIF
RETURN 
>I am creating a parameterized view. The view returns, for example, 4 records. On my form I have a navigation button that will scroll through the 4 records. When I bring up the form, the record that I land on is record 1. How can I land on record number 3 for example and still maintain the result set of all 4 records to go back and fourth? I want the ability to land on a particular record when I bring up the form but also allow, if the user clicks, navigation button to scroll thru all 4 records that I found through parameterized view. Help appreciated
>
>
>thanks
>nick patel
Charlie
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform