How To Sort the Table Through Push Buttons (ASC & Desc)??? [message #137865] |
Sun, 18 September 2005 01:54 |
ramisy2k
Messages: 150 Registered: April 2005
|
Senior Member |
|
|
Hi,
I am facing a problem with regard to 'Push Buttons' that I have created on
my Form. I want the 'Push Button' to sort the table with respect to a
specific column in 'Ascending order' on first push and then in 'Descending
order' on second push and then again in 'Ascending order' on third push and so
on...
please help me to achieve this
regards,
|
|
|
Re: How To Sort the Table Through Push Buttons (ASC & Desc)??? [message #137923 is a reply to message #137865] |
Sun, 18 September 2005 21:25 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
In your when-button-pressed trigger, test a global to see whether it is the 'odd' or 'even' button press, set this global to the 'othert' value, set the 'order by clause' on your data block to be the field in which you are interested with 'asc' or 'desc', then do an execute_query.
David
|
|
|