Home » Developer & Programmer » Forms » Sort
Sort [message #203511] Wed, 15 November 2006 06:17 Go to next message
vatsjai
Messages: 23
Registered: May 2005
Location: delhi
Junior Member
Hello to all oracle gurus

Hi

I have a problem regarding sort. I have a table with data in punjabi(india punjab language) and it is converted into english alphabets.I have entered this data into table by forms.
I want to sort this table with this columnwise. How i can do that please suggest something urgently.

Jai
Re: Sort [message #203513 is a reply to message #203511] Wed, 15 November 2006 06:25 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just like you'd do that in SQL - use ORDER BY clause.

In SQL:
SELECT * FROM your_table
ORDER BY this_column;

In Forms, go to block property palette and, into the 'Order by' property, enter this column name.
Re: Sort [message #203552 is a reply to message #203513] Wed, 15 November 2006 08:53 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi,

r u entring data into Punjabi?? and Oracle is converting it in English.

Re: Sort [message #203817 is a reply to message #203552] Thu, 16 November 2006 07:38 Go to previous messageGo to next message
vatsjai
Messages: 23
Registered: May 2005
Location: delhi
Junior Member
hi

I enter data in a text box with punjab font. so it shows data in punjabi but when i commit_form then it is posted in oracle table.
Oracle does not suppor alphabet (ura,erra in punjab) so it converts them in english alphabets. If i sort on this column then it will sort form a to z which is not my requirments.I hope u do understand?


Jai
Re: Sort [message #203820 is a reply to message #203817] Thu, 16 November 2006 07:43 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In other words, front end (your form) uses one font (according to regional settings you have set), but database uses another - different - NLS setting. Am I wrong or not?

Oracle sorts data using an ORDER BY clause. What happens if you set your database to use required NLS? I don't know which one it is, but *suppose* that there must exist one that will suit your needs.
Previous Topic: How to Put value for query in Display Item Forms 6i
Next Topic: Book on Forms and Reports
Goto Forum:
  


Current Time: Fri Dec 02 12:34:25 CST 2016

Total time taken to generate the page: 0.15130 seconds