CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.

YesSoftware Forums -> CodeCharge -> Programming

 Adding/Displaying custom columns

Print topic Send  topic

Author Message

Posts: 5
Posted: 02/06/2006, 5:19 PM


Trying to coming up with ways to allow the application end user to add additional columns to a table, and then for the display page to list all columns including any newly added ones in a grid. Doing this programmatically outside of CodeCharge would not be a problem, but would welcome any tips or ideas on a specific CodeCharge way of doing this..

Many thanks!

View profile  Send private message

Posts: 509
Posted: 02/06/2006, 11:01 PM

What I do.
Placing a label Caption beside the actual caption (Sorter control for example) of a table column.
Placing a label Data beside the control in the table cell below the corresponding column caption.

Lets assume the form containing the table is named Plan.
In Before Show Event of label caption
Plan.Caption.Value = "</TD><TD>Additional Column"
and in Before Show Event of label data
Plan.Data.Value = "</TD>Additional Data<TD>"
Of course the retrieval of the extra data could be more complex as simply putting a string there.
Actual language is ASP.

Best regards,
View profile  Send private message

Posts: 5
Posted: 02/07/2006, 3:22 AM


Thanks for the reply!

Maybe I wasn't clear on what I want to do - I want to create dynamic bound datagrids and template columns. The end user will be able to add columns to a table, therefore I won't know how many columns or of what type a SELECT * FROM X query will return.

I'd like to know if there's a given CodeCharge way of doing this, rather than write custom code.

Thanks again,
View profile  Send private message

Posts: 1712
Posted: 02/07/2006, 9:45 PM

I can definitely say with my CCS experience that what you are requesting is something that you are going to definitely have to custom program.
View profile  Send private message

Posts: 5
Posted: 02/08/2006, 12:45 AM

Mambo, seems you are right!

So what I'm left with is something like

Select * from table into an array, then use array as grid.

Not sure about paging/sorting..
View profile  Send private message

Posts: 1712
Posted: 02/08/2006, 8:40 PM

Yes, you seem to heading in the right direction. Here are some links to help you out:

Here are some examples of how to create dynamic HTML:

This is the basis of the technique that you will need to use to accomplish your goal:

Hopefully this will be helpful.....

I used this technique to create a calendar in CCS 2.3:
I even wrote an article about it as well (November 2004 issue):
View profile  Send private message

Posts: 5
Posted: 02/09/2006, 1:32 AM


Excellent, thanks very much!
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.