Dear all,

I found a very trouble problem in database development. My coding is only retrieving data from database and then displaying them. The SQL command is "Select * from test". When the data type is numeric, data values all are retrieved to be ZERO. But others are correct. When I tried to use "Select to_number(amt) from test", it can retrieve the correct value ( not '0'). Why???

My system environment is:
OS: Win98
Database: Oracle 8i
VB: 6.0
Connection: ADO

Thanks for your attention and help!!!

Best Regards,
Grace