CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Changed DB field name: field no longer updated upon edit

Print topic Send  topic

Author Message
gpdeering

Posts: 57
Posted: 04/27/2006, 8:53 AM

Peculiar problem here.

Background:
I used the application builder to generate two pages: the first one is a list view with record search and the second is the record edit page. Simple standard stuff here.

But then I decided to rename one of the fields. This field, we call it fieldX, was renamed to fieldY. So, one by one, I renamed the appropriate controls and changed the control source properties for that field on the edit page and on the list page. I also added it to the search form (fieldX was not originally there, but now fieldY is). In the list datagrid, I added (LIKE %{s_fieldY}) to the WHERE clause.

Problem:
When I click on a record ID to edit the record, the data from fieldY is missing. I get a blank field.

I thought I had renamed and reconfigured everything, but I'm missing something here.


Any ideas?


Thanks,

--Glen
View profile  Send private message
peterr


Posts: 5971
Posted: 04/27/2006, 10:28 AM

This happened to me too in the past. Usually I just missed something and found it after a while.
I can only offer couple tips:
1. Delete the whole generate code (like PageName.php) and re-generate it.
2. Open the file PageName.ccp and search it for the old field name.
Sometimes I change control source only by opening PageName.ccp and doing automated search & replace on values right there.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
WKempees
Posted: 04/27/2006, 3:37 PM

And,
- Press "refresh" on the Connection in Project Explorer.
- Open the DataSources to check that FieldY is in the SELECT part of your
SQL.(you write you added fieldY to the Where part).

gpdeering

Posts: 57
Posted: 04/28/2006, 5:58 AM

Peterr, WKempees:

I couldn't find anything abnormal (to me) in the .ccp files. Yes, my DB had been refreshed.

Fortunately, there was not very much custom coding in this app, so I just regenerated the whole thing in 30 minutes. (I love CSS!) Mystery unsolved but it doesn't matter anymore.

Thanks.

--Glen
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.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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