SQL command
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL command

  1. #1
    Join Date
    Feb 2001
    Posts
    15

    Question

    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

  2. #2
    Join Date
    Oct 2001
    Posts
    8
    Gracetam,

    I think this query will help you.

    select nvl(amt,0) from test;

  3. #3
    Join Date
    Feb 2001
    Posts
    15

    Question

    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
  •  


Click Here to Expand Forum to Full Width