Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying Text on Grids
Message
From
29/08/2001 17:37:07
 
 
To
29/08/2001 17:33:46
John Tomblin
Service Station Systems, Inc.
San Jose, California, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00550594
Message ID:
00550597
Views:
15
>The RecordSource for a grid is a table. The Table contains severl fields that hold codes which don't have meaning to the end user. I have functions that translate these codes into understandable text. Those grid columns that would display the decoded informations are read only. Other columns need to be editable.
>
>I have tried putting the decodeing function as the ControlSource and putting code in the refresh for the grid's TextBox, neither work. I'm sure others do this on grids but I'm having no luck.

This where using a SQL Select statement to populate a cursor for displaying in the grid would be nice. If you need it to be updateable you could create a local view. Parameterized, probably.

Or, you can display the related fields in comboboxes in the grid, if you want to let users pick values based on the human name and not the code. This works alright, but combos in grids *can* slow things down. And you have to remember to set sparse = .f.
Previous
Reply
Map
View

Click here to load this message in the networking platform