CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 New DB Fields not showing in control source listbox

Print topic Send  topic

Author Message
Dreamcatchers


Posts: 118
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?
_________________
Dream Catchers, Inc
ITIL Training and eLearning
www.itil.us.com
866-FOR-ITSM
View profile  Send private message
solesz

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

Hi,

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
solesz

Posts: 135
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 http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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