Jock
Posts: 5
|
| Posted: 04/02/2009, 6:51 PM |
|
I'm sure this has been asked & answered but I can't seem find it.
I've added a new column to a database and now need to add it to the grid.
Even though it is added to Design screen, nothing for the column gets generated in the ASP code hence nothing shows.
Can I force ASP to include this in the code or do I have continue with what I presently do, i.e.: - hand code it?
|
 |
 |
Oper
Posts: 1195
|
| Posted: 04/03/2009, 7:56 PM |
|
Insert a Column is Just Insert a column and the put a lable assigna field and ready.
but
Quote : presently do, i.e.: - hand code it?
if you do that, after that nothing ind designed will be added.
you have 2 post maybe you already know, but never modify the Grey Text(generated by Codecharge)
but the place specific for that.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Jock
Posts: 5
|
| Posted: 04/04/2009, 1:50 PM |
|
Actually no it doesn't.
When I add the field to the grid, it "appears" to be added but no ASP code gets generated to add it to the recordset.
In other words, it's visible in design mode but it's not actually available for use.
Somehow ASP is not aware of the change to the record structure and therefore does not include it.
However if I hand code all the requisite lines, it now becomes part of the set.
I'm wondering if there is some step I need to make to alert ASP to the presence of a new column otherwise this would seem to be a deficiency.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 04/05/2009, 5:27 AM |
|
is just and insert Colum, it shoudl work perfect, so somethign is wrong in your CODE.
if you add a Column and add a label and use before show and force a value like
sender.value="Here i'm"
does it show during run time?
also if you have a "small" Project with the issue i may try to help.
notice small
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Jock
Posts: 5
|
| Posted: 04/05/2009, 3:55 PM |
|
OK, I think we're talking about two different things.
Let me try to clarify
1 I create a new column in the database (MS SQL)
2 In CCS designer I include the new column in the query
3 I then add a new text field to the grid and set its source to the new column
4 I publish the page and the new column does not appear.
Viewing the source indicates that this field is empty - no data.
Clearly it is not being filled when the SQL query is run against the database the reason being that nothing is generated in the code behind page.
A manually check for the relevant lines which would define this column reveals this.
This is not an ASP issue per se but rather that once the grid has been built, I can't seem to add any new fields to it unless I either rebuild it from scratch or manually type in the lines to include the new field(s).
I don't believe that I should have to rebuild the grid from scratch each time I change the database structure.
|
|
|
|
vandalen
Posts: 58
|
| Posted: 04/06/2009, 11:00 AM |
|
When you are in the query designer and view data, do you see any info populated on the new column?
|
|
|
|
Jock
Posts: 5
|
| Posted: 04/06/2009, 5:35 PM |
|
It appears to be an issue with complex screens.
I've built a couple of simple screens and they work as expected but time and time again on more complex screens, the generator remains blissfully unaware of the change in database structure.
Could possibly that some internal structure or pointer is not being handled correctly.
I suppose the solution is to simplify the screen - which is my next plan of action anyway as it's causing some other issues.
|
|
|
|
