Henry
|
Posted: 12/09/2003, 11:45 AM |
|
This drove me crazy. I had an editable grid that containe a couple of listboxes. I could update them but the grid would NEVER show the values, only SELECT VALUE.
CC Support kept saying the listbox will display the value in the database, but it wasn't.
Finally figured it out. My data in SQL Server was a type of CHAR. Changing it to VARCHAR fixed my problem. Since a CHAR field with a 10 char length has a value like "X2 " if your validation list or table is looking for "X2" it won't match and you won't get any data in your boxes.
VARCHAR VARCHAR VARCHAR...
|
|
|
Edd
|
Posted: 12/09/2003, 1:32 PM |
|
If you think that will drive you crazy - Try DateTimes in a listbox - that is a nightmare, they all get truncated to dates - then to Chars. To get around you need to build your own listboxes.
|
|
|
|