Wednesday, March 7, 2012

Decimal DataType

Good Morning

Shopping for a bit of assistance with the decimal datatype in a SQL Server 7.0 database. I am sending data with 2 decimal places from a
VB6 program to the databse table and the decimal positions are getting cut-off. IE .10 is turning into 0. I have the field in my databse table
defined as decimal, 5 long and a precision of 2. Any ideas what I am doing wrong?

Thanks for the help,
EJDHow is the vb veriable defined?|||CDec(cobjCustomRS("CustomNumber"))

No comments:

Post a Comment