OraFAQ Forum: Designer » Tough question in Designer

Home » Developer & Programmer » Designer » Tough question in Designer - Sort order

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tough question in Designer - Sort order [message #85181]

Mon, 07 June 2004 16:29

Dhana
Messages: 5
Registered: December 2003

Junior Member

I use Oracle designer to develop the form. I have a simple table to be shown on the screen for maintenance.

I want to sort a column that has mixed-case values. I require something like

order by UPPER(COL1) in my sql query

If I use the designer bound item sort - Order by sequence, the query becomes

order by COL1.

How to make this column to sort using UPPER using designer.

Please note that this can be easily fixed if I edit .FMB. But I want to fix this in the Oracle designer repository.

Thanks for your time.

�

Report message to a moderator

Previous Topic:	Save Designer ERD-diagram as a picture
Next Topic:	problem with oracle designer repository 6i installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 07:26:19 CST 2024