Home » Developer & Programmer » Designer » Tough question in Designer - Sort order
Tough question in Designer - Sort order [message #85181] Mon, 07 June 2004 16:29
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.

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

Current Time: Wed Mar 22 17:40:00 CDT 2023