How to display text data in the same case as it is in databa

system · July 29, 2004, 4:06pm

Text data in the database is in upper case but when displaying BO converts their case to Init case. I want to display these data as it is in database. Can anyone tell me how to do that? I don’t want to use any function, is there any setting using which I can solve this problem.

ManasP (BOB member since 2004-03-09)

system · July 29, 2004, 4:19pm

What DataBase are you using?

Donald Duck (BOB member since 2004-07-29)

system · July 29, 2004, 4:21pm

I am using Oracle database

ManasP (BOB member since 2004-03-09)

system · July 29, 2004, 4:24pm

Please tell me what Designer object has this problem!

How is that object defined in the Designer?

Are you using the upper Oracle function in Designer?

Donald Duck (BOB member since 2004-07-29)

system · July 29, 2004, 5:21pm

I am using these objects as Detail objects of Character type.

No I am not using any oracle functions. I don’t want to manipulate the case thus not using any function. I want the case should be as it is in db.

Thanks

ManasP (BOB member since 2004-03-09)

system · July 29, 2004, 5:23pm

I am using these objects as Detail objects of Character type.

In my system I never use DETAIL objects: I think they are completely useless.

I’m sure that if you REDEFINE the DETAIL objects as DIMENSION objects, this problem will disappear.

Can you try?

Donald Duck (BOB member since 2004-07-29)

system · July 29, 2004, 5:30pm

No buddy, no difference.

ManasP (BOB member since 2004-03-09)

system · July 29, 2004, 5:44pm

One advantage of detail objects is that they cannot be linked across data providers, which might improve computation time when displaying blocks, which combine data from multiple data providers.

A) Can you post the SQL code of the data provider?
B) Are any local report formulas applied to your cell?

Andreas (BOB member since 2002-06-20)

system · July 29, 2004, 8:11pm

Are you sure? Can you query the text data in the database with another tool?

If you are seeing the data via some other report or panel, perhaps that report or panel is upper-casing the data, and the data really is in mixed case in the database.

Anita Craig (BOB member since 2002-06-17)

system · July 29, 2004, 10:49pm

Anita is right. You should run the same query in SQL Plus and compare the case with your report.

kashif

Kashif Saeed (BOB member since 2004-06-02)

system · July 29, 2004, 10:54pm

I agree with everyone here. BO does not alter the data unless you tell it to do so. It’s possible that your data entry screen is UPPERing it before it stores it.

Steve Krandel (BOB member since 2002-06-25)