Incorrect data of column 2

[tsusnik]

I have two columns (id, code) from one table. Id is a number, code is a string. The correct output would be:
1,00 01245
2,00 01465
3,00 02546

But I get the output:
1,00 1
2,00 2
3,00 3

The code gets the same value as id but it is still a string. I get the same result when I browse data.

Thanks for any suggestions!

 

[PKG]

Hi "tsusnik"
Try doing a verify database command.
Database Menu > Verify Database

-PKG

 

[tsusnik]

No, that doesn't do it. I get the message "The database is up to date." and everything stays the same.

Tomaz

 

[PKG]

Are you sure that the field which is showing 1,2,3 is "code". When you move your mouse over the field it shows the database field name. Make sure that it is nothing but the code.
It should show the actual values. 01245, 01465, 02546.

-- PKG

*************************
Pradeep Kumar Gupta
Data Warehouse Consultant.
E-Mails: pradeep.k.gupta@indiainfo.com
pradeep.gupta@morganstanley.com

 

[tsusnik]

It definitely is "code" and it definitely is a string although I have no formula at all.

This problem is very curious. Could there be some problem with the database (Oracle 8i)? But when I select the data with a query in SQL Plus the result is correct.

Tomaz

 

[PKG]

S T R A N G E !!

I have not come across any such situation.
May be there is some problem in database drivers.

Try one more thing, Do a "show sql" and copy the sql from there, Run that SQL in another query tool like SQL plus and see what result it is giving.

--PKG *************************
Pradeep Kumar Gupta
Data Warehouse Consultant.
E-Mails: pradeep.k.gupta@indiainfo.com
pradeep.gupta@morganstanley.com

 

[tsusnik]

As usually in such cases it was a stupid mistake of mine. The user of the database was wrong! I was using table user1.table instead of user2.table.

Thanks a lot - your last answer helped me. I saw my mistake in the Show SQL.

Very sorry for bothering you.

Tomaz