mantiscomputing
Posts: 11
|
| Posted: 04/06/2005, 4:50 AM |
|
Hi
I renamed a field in my databse (MySql) from 'c-g' to 'c_g' and now it doesn't apper in the labels properties drop down, I am trying to add a label to be populated from this field.
How can I get the newly named field to appear?
|
 |
 |
Nicole
Posts: 586
|
| Posted: 04/06/2005, 4:59 AM |
|
Hello,
You need to refresh database connection: select connection name in Project Explorer window, and select Refresh from right click menu.
If new field does not appear in a Control Source list, open Data Source dialog of the form and open Visual Query Builder. There check that new field is listed and flag next to it is checked (or asterisk flag is checked).
_________________
Regards,
Nicole |
|
|
|
mantiscomputing
Posts: 11
|
| Posted: 04/06/2005, 5:18 AM |
|
Hi
I have tried those suggestions but still no luck.
In the visual query builder it is showing in the table list (I have the * ticked) but when I click on 'Review data' on the 'Data Source' the field is missing from the results.
The data source type is 'Table' if that helps.
|
|
|
|
Nicole
Posts: 586
|
| Posted: 04/06/2005, 5:38 AM |
|
Do you see a new field in Visual Query Builder?
_________________
Regards,
Nicole |
|
|
|
mantiscomputing
Posts: 11
|
| Posted: 04/06/2005, 5:47 AM |
|
The VQB has nothing in it at all, if I click on the 'Review data' button at the bottom left it returns data but my field is missing.
If I click on the + icon at the top to add the table in that table window I can see the new field.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/06/2005, 1:17 PM |
|
You may need to re-select your table again in VQB. Minimum 1 table must be selected there.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Damian Hupfeld
|
| Posted: 07/24/2005, 4:18 AM |
|
If you are still having troubles with this check whether you replicated your
server database to your local development database. I have dont this a few
times... added an extra table or field to my live project after I had
published it, but CCS still looks at your development database...
regards
Damian Hupfeld
http://www.nexthost.com.au/services.php
"mantiscomputing" <mantiscomputing@forum.codecharge> wrote in message
news:54253da4ab4a9e@news.codecharge.com...
> The VQB has nothing in it at all, if I click on the 'Review data' button
> at the
> bottom left it returns data but my field is missing.
>
> If I click on the + icon at the top to add the table in that table window
> I can
> see the new field.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
