CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Editable Grid Listbox SQL Server -- USE VARCHAR!

Print topic Send  topic

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




   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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