Henryk
Posts: 63
|
Posted: 06/12/2008, 2:19 PM |
|
I have a label on my record that is not showing up when I view the record. The field is a text field in a mssql db. Initially it did populate the data, but after I made some additions to the record view, not touching that particular label, it stopped showing up. I tried deleting it and readding it, putting it in twice, changing it from a label to a text box, all to no avail.
|
|
|
TheunisP
Posts: 342
|
Posted: 06/12/2008, 3:11 PM |
|
just check if you are actuallly returning that value ftom the database e.g. using a select * or if you specified it in the select by name
|
|
|
Henryk
Posts: 63
|
Posted: 06/13/2008, 3:58 AM |
|
Select * is in the data source :) One of the first things I checked.
|
|
|
wkempees
Posts: 1679
|
Posted: 06/13/2008, 4:05 AM |
|
Quote Henryk:
Select * is in the data source :) One of the first things I checked.
You do this in VQB I suppose, If you press show SQL it shows up, if you press Show Data does it show up as well?
If so, that part seems ok.
Now,if you look at the properties of your label, is it showing the field from Datasource correctly?
I mean is your newfield in the list?
There are several places where you can press "Refresh" on the datasource.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
Henryk
Posts: 63
|
Posted: 06/13/2008, 4:19 AM |
|
It is for a record, so there is a primary key filter in there, so no data shows up.
|
|
|
wkempees
Posts: 1679
|
Posted: 06/13/2008, 4:49 AM |
|
On PhP, MySQL through ODBC for design mode
Record form, datasource, pressed [...], in VQB pressed showSQL icon, works
pressed Show Data Icon, shows all rows! [Table mode]
SELECT *
FROM events
WHERE event_id = {event_id}
the above is the SQL
??
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
TheunisP
Posts: 342
|
Posted: 06/13/2008, 5:05 AM |
|
hidden CCS feature
|
|
|
Henryk
Posts: 63
|
Posted: 06/13/2008, 5:17 AM |
|
I did not get any records passed back doing that (probably an issue between the keyboard and chair). I changed the text field to a varchar field in the db (which truncated my data), Then opened the page and the field was populated. I switched it back to a text field, and it dissapeared again. Since that did not solve my problem, because I can't have the data truncated (too large for a varchar data type), I went ahead and restored the table and I am slogging through trying to figure out why a text field would not show up. It stopped appearing I believe when I added some listboxes to the record form, which were tied to another table. I am going to try switching to list of values for my dropdown and see if that fixes it (since I already had one dropdown with listofvalues with no issues). Then removing those dropdowns entirely if the list of values does not fix it.
|
|
|
wkempees
Posts: 1679
|
Posted: 06/13/2008, 5:25 AM |
|
set the Recordfield type to Memo.
Properties->DataType
Walter
BTW who is on your lap?
If between keyboard and chair is not you?
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
Henryk
Posts: 63
|
Posted: 06/13/2008, 5:37 AM |
|
I already tried changing to memo several times, to no avail. Removing those listboxes made the field populate again, however. So now, I need to figure out what about those listboxes is causing that one field to dissapear. I am going to take it step by step here, adding the listboxes with no db associations first. Then adding associations, then adding values for the dropdown list.
I can't talk much about my lap for fear of HR paying me a visit.
|
|
|
wkempees
Posts: 1679
|
Posted: 06/13/2008, 5:39 AM |
|
Ok, well you are on your way (and (not) on your own)
Good luck, happy travel.
Await a detailed report of course.
(on the solution that is)
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
Henryk
Posts: 63
|
Posted: 06/13/2008, 5:43 AM |
|
Well, It looks like it breaks down as soon as I add a control source to the listboxes. The odd thing is, I already I have one listbox in there. This looks to be something I may need to get with support on, since I have no idea what causes it to break at that point.
Just for fun, I am going to add the field to a seperate form on the page and see if it shows up
|
|
|
Henryk
Posts: 63
|
Posted: 06/13/2008, 5:52 AM |
|
In a new form, or recerd view I guess you could call it, on the same page, the data does in fact show up. In this case, due to the size of the contents of the field, I can probably get away with doing it this way and formatting the layout to act like it is supposed to be that way, but it probably is not a good fix.
|
|
|
wkempees
Posts: 1679
|
Posted: 06/13/2008, 6:39 AM |
|
It is not a fix, it's a workaround.
Ask support on the original page http://support.yessoftware.com.
Be prepared to make a copy project containing only the problem page,
working and with the reproducable problem.
W.
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
Chris__T
Posts: 339
|
Posted: 06/13/2008, 12:54 PM |
|
i don't usually fill in the control source property when I have a listbox. Is your control source Type set to Database column? If so, just deal with connection, datasource type datasource properties. Plus bound and text columns, of course
|
|
|
|