CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Editable Grid Listbox SQL Server -- USE VARCHAR!

Print topic Send  topic

Author Message
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.

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.


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

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