j9
|
| Posted: 08/24/2004, 7:43 AM |
|
Probably an obviosu question, but here goes... In CC 2.0 I could populate a Grid column base on a list of values. For example, the column in the DB holds a number, but I want to display a label. Works just like LOV would work in a Record view.
The problem is that if I change the column from a label to a List box, the thing shows a pull down list box, and that i not what I want. I do not want th user to change anything - just see the correspodning text for the number that is inside the DB.
I realize I can do custom code in before show, or that I could create a lookup table in the DB and bind to that, but isn;t there another way?
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 08/26/2004, 6:48 AM |
|
Hello,
CC in fact builds a query that joins two tables and you see Text value.
In CCStudio you can build that query by yourself. Open grid’s Data Source dialog and click on Build Query button to open Visual Query Builder. There you can join table and select fields you need to be displayed on a live page
_________________
Regards,
Nicole |
 |
|
j9
|
| Posted: 08/27/2004, 1:14 PM |
|
Hi Nicole,
I realize I could do this by building a query which joins two tables, but in fact I did not want to create a second table just to have labels for these values. In CC I could just do a list like 1;End User;2;Administrator. The field I am showing is security level and I wish to associate the name. Ideas?
|
|
|
|
iktorn
|
| Posted: 03/04/2005, 11:30 AM |
|
Is this possible in CCS?
|
|
|
|
google
|
| Posted: 03/04/2005, 11:32 AM |
|
http://google.com
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/04/2005, 9:58 PM |
|
I think that you cannot use such method in CCS, therefore you would need to use CCDLookup function or some custom code.
The usual supported method is to join multiple tables as CCS examples and tutorials show.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
