Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Landing on a particular record in a view
Message
From
29/07/1999 12:28:26
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00247717
Message ID:
00247750
Views:
23
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform