CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 New DB Fields not showing in control source listbox

Print topic Send  topic

Author Message

Posts: 120
Posted: 07/22/2016, 7:05 AM

I added 2 new fields to the employees table. Database is SQL Server 2012, Language is ASP. Version is CCS 4.3. This does NOT occur with CCS 5.1. I still have some sites I manage in 4.3, therrefor the question.

In the past, new fields added to the database would show in the control source listbox when creating forms or grids. I know to close codecharge studio and reopen if a database change was made.

This time these fields don't display. I can manually type them in the control source field rather than selecting from the list.

What could be causing this behaivor?
Training and LMS Developer
View profile  Send private message

Posts: 137
Posted: 07/22/2016, 9:59 PM


When you update the database under an open CCS session you have the possibility to refresh the meta info by opening the datasource editor (of the relevant record) clicking on the ... besides the datasource field in the properties panel.
Then opens the darasource editor, where you can find a button with two circular arrows, this is the refresh button.
Then you should already see the new database fields in the editor. You have to check if the new fields are selected in the SELECT part of SQL or * is used for selection.
If you still do not see that field in CCS, but typed directly into the control source it works, then probably you have problem with the connection definition (project settings) with the design time database connection.
View profile  Send private message

Posts: 137
Posted: 07/22/2016, 9:59 PM

Removed, duplicate of the previuos comment.
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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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