ColinH
Posts: 15
|
| Posted: 12/09/2006, 4:54 PM |
|
Hi
I have used grids to display values from a table and a form to add/edit the values for each record. For a number of columns I have used a list box in the form (with a lookup table) as I have a code value/bound column (stored in the database) and a more descriptive value/ text column for the user to choose in the list box. This all works great.
The issue is when the values are displayed in the grid, the database value is displayed and so the grid shows the abreviation or code value. What I'd like is for the grid to show the descriptive value.
Here is what I've tried - Change the Label to a List box in the grid and specify the datasource, bound column and text column. This works BUT the list box is active allowing the user to select any value of the drop down list - when selected a new value is then displayed. As the grid is not editable this is NO OK. The changes are not made to the database and the screen/grid is displaying a different value.
I short how do I display the "text column" value rather than raw database value for a column in a non-editable grid? This must be a very common requirment but I couldn't find it in the help or other docs.
Thanks
|
 |
 |
Edd
Posts: 547
|
| Posted: 12/09/2006, 8:22 PM |
|
Colin,
Sorry your explanation is a bit confusing so I am gint to guess that this is not an editable grid.
If that us the case the change the database grid datasource (edit query) and link the lookup tables to extract the descriptions - ensure they are Outer joins.
Look at the examples in the CCS example pack.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
ColinH
Posts: 15
|
| Posted: 12/10/2006, 7:29 AM |
|
Thanks Edd,
I'll take a look at the examples. Good to know "that's how you do it in codecharge" - at least I'm looking at and learning the right approach.
Yes it is a non-editable grid
|
|
|
|
ColinH
Posts: 15
|
| Posted: 12/10/2006, 8:17 AM |
|
Edd,
I've got it to work whcih is great - thanks.
Just for curiosity though (and my ignorance) - there is no option for an OUTER join that I can find. I'm using an INNER join and unchecking the column values except for the column I want. DB is Oracle.
BTW - CCS seems a little sensitive on the alias name used for the join - the default one (very long) doesn't work (displays nothing in the grid) but if I create an alias name that is shorter then it works...
Thanks again for the help !
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/10/2006, 11:56 AM |
|
You can right-click or double-click on a join to configure it (INNER, OUTER LEFT & RIGHT).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
