Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help- Sql Server and VB 6.0 application

Status
Not open for further replies.

Tweetiepie

Programmer
Jul 13, 2001
7
GB
Hi,
I am using an Sql server to hold the database for the data of the Vb application. In one of the tables i have a value which is declared as a varchar with size of 255.
When i reference this value to put into a text box it seems to rounding the numbers. If i enter in 2.5 as input.. this is saved in the db and then when i reference this again as the data for the text box it comes up as 2.4444444498. Is there a conflict of data-types between sql and vb that might be causing this? or is there some other obvious explaination which i cant figure out.
Your help would be much appreciated.
Thanks a million
viv
s-)
 
I got the same problem.
Kindly send me any useful reply at vincent.mairiaux@yucom.be

Thanks a lot.
Vincent
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top