Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Keeping Track of Row and Column in Grid Upon Requery
Message
From
02/01/2001 02:09:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00458363
Message ID:
00458402
Views:
17
>I have 7 grids on 7 pages of a pageframe on a form to display the Parent and 6 child Views of the Main form. I have added a textbox class to each column on each grid for doubleclicking the grid/cell and have an event or procedure fire. I use it to launch my "zoom in" form to zoom in on the currently selected record.
>
>While on the "Zoom In" form your able to navigate through the records of the child table. When I close the form and return to the grid I notice the grid doesn't update unless I issue a Requery command, however that causes the record pointer in the child view to move to the top of the currently selected records.
>
>I want the Grid to keep track of where I'm navigating in the "Zoom In" form and be on that record when I return.
>
>In the main form's data environment I have just the Parent View. This is because most of the time the user may only open 1 or 2 of the child views and I didn't want to have all 6 child views opening everytime. So on the Activate method of each page I call a custom method "GetView" to open the needed view and Requery to refresh the grid(s).
>
>Do I want to use the ActiveColumn and ActiveRow properties to track my location in the Grid?
>
>Thanks ahead of time.

Elgin,
ActiveRow would typically be same as recno() and using recno() is better IMHO. However since this is a view neither recno() nor activerow might point to previous record after an update. If possible use an identifier key (I use a key for childs too though they wouldn't have any child).
For Activecolumn using controlsource (hence the fieldname) sounds better.
I don't recommend ActiveColumn and ActiveRow properties because they slow down grid operations.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform