Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referencing grid values of different cells?
Message
From
11/05/1998 18:21:13
 
 
To
11/05/1998 17:44:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00098599
Message ID:
00098615
Views:
27
Matt - Open the table the grid is using AGAIN with a different Alias:

* Form Load Code:
Use GridTable In 0
Use GridTable Again In 0 Alias GT_lookup

Put the two tables in the same order so that the lookup table will have the same previous and next rows. Then, instead of using the ActiveCell method you should maintain a property .r_nRowNow_GT which contains the current row as referenced by a reliable lookup key. It can be RecNo() but it is preferable to use a primary key because then you don't have to worry about going to a record that isn't there. You can save the new value in the When code for each of your grid objects. Then when you want to validate the dates above and below, that method can find the record specified by Thisform.r_nRowNow_GT and SKIP or SKIP -1 to get the values above and below.

Adam





>Could someone enlighten me as to how I can reference values in different cells within a grid without using the ActiveCell method?
>Is it possible? I'm trying the verify dates in cells above/below and beside the active cell.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform