Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying Text on Grids
Message
From
30/08/2001 05:45:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
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:
00550738
Views:
12
>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.

John,
In an editable grid any calculated column is readonly by default and cannot be made editable. For calculated columns generally it's extra parentheses that make it work. ie: For orders table you could have a form method calculating net value based on amount, discount and tax percentage :

NetColumn.controlsource = ;
'thisform.calcval(orders.order_amt,orders.order_dsc,10)'

would work. However making it :
NetColumn.controlsource = ;
'(thisform.calcval(orders.order_amt,orders.order_dsc,10))'

is more reliable.
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
Reply
Map
View

Click here to load this message in the networking platform