Home » Developer & Programmer » Forms » How to sort values in columns. (Forms6i)
How to sort values in columns. [message #378645] Wed, 31 December 2008 03:47 Go to next message
adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo
Member
Is there any way to sort the values in columns from the picture?
For example, i have three columns: empno, ename, job, with the values:

empno ename job
1 Jasmin manager
2 Adnan manager
3 Chuck worker

I would like to get this order by the ename parameter:

empno ename job
2 Adnan manager
3 Chuck worker
1 Jasmin manager

Thx in advance.
  • Attachment: sample.JPG
    (Size: 15.42KB, Downloaded 511 times)
Re: How to sort values in columns. [message #378658 is a reply to message #378645] Wed, 31 December 2008 04:27 Go to previous messageGo to next message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Open datablock's Property Palette window; go to its Database node and enter "order by ename" into the "ORDER BY Clause" property.
Re: How to sort values in columns. [message #378692 is a reply to message #378658] Wed, 31 December 2008 06:49 Go to previous messageGo to next message
adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo
Member
Littlefoot wrote on Wed, 31 December 2008 11:27
Open datablock's Property Palette window; go to its Database node and enter "order by ename" into the "ORDER BY Clause" property.


Thx for reply, but I mentioned on how to sort values dynamically (as you could sort columns in Excel, for example).
Re: How to sort values in columns. [message #378705 is a reply to message #378692] Wed, 31 December 2008 09:44 Go to previous message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Adnan
I mentioned on how to sort values dynamically
You did? Where, exactly?

Use SET_BLOCK_PROPERTY built-in's ORDER_BY parameter.
Previous Topic: form error
Next Topic: make bill in form builder
Goto Forum:
  


Current Time: Sat Nov 09 19:28:58 CST 2024