Dreamcatchers
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 |
 |
 |
solesz
Posts: 137
|
| 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.
|
|
|
|
solesz
Posts: 137
|
| Posted: 07/22/2016, 9:59 PM |
|
Removed, duplicate of the previuos comment.
|
|
|
|
|
