rounding the numeric values

Hi,

I have an vb6 application using sql server and udb at the back end.
In the grid , I want to display a numeric value ex: 123.4562.
I have declared the value as numeric (15,5).
The stored procedure modifies or adds the value to the table.
when I connect the application to UDB, the column displays the numeric value in the grid. when I connect the application to SQL server, the columns displays the value 123.00000.
The sql stored procedure works fine if I pass the numeric value in query analyzer saving the numeric value in table. but in the application it shows me as 123.0000. The same application when connected to UDB works fine.
Can some body help me with this problem.
Thanks

Welcome to the Forums. :)

Moved from VB FAQs forum.

What is a UDB? Post your code.

What is UDB?

Quote:

---

Originally Posted by szlamany

What is UDB?

---

User database?