-
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
-
Gracetam,
I think this query will help you.
select nvl(amt,0) from test;
-
Dear gurao,
Thanks for your reply.
I tried your sql command, but all displayed are blank. Also, I tried to run "select * from test" in Oracle ODBC test, it can display correct values, not all are zero.
Is it the front-end software problem?
Best Regards,
Grace
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|