Topic: Sort tables by button in SQL

Hello everyone, I would like to know how to sort a table in alphabetical order by a print button in SQL.
Is it possible ?

I have a list here:
---------------------------

Post's attachments

Attachment icon Livre.jpg 11.91 kb, 21 downloads since 2022-10-27 

2 (edited by sparrow 2022-10-28 07:48:12)

Re: Sort tables by button in SQL

Hi,


If you are using an SQL query, then use the construct to sort

SELECT Field1, Field2, Field3 FROM Table WHERE ... ORDER BY Field2  ASC

where you use any field or multiple fields and sort priority

SELECT Field1, Field2, Field3 FROM Table WHERE ... ORDER BY Field3 DESC, Field1 ASC

ASC asceding sort or use DESC - desceding sort


If you use other possibilities, please indicate what exactly or attach an example.

Re: Sort tables by button in SQL

Hello sdpc, Hello Sparrow

Tu souhaites ce tri pour affichage dans un état (*.fr3) ou simplement affichage visuel de la grille ?

You want this sorting for display in a report (*.fr3) or simply visual display of the grid. ?

JB

Re: Sort tables by button in SQL

Super Moineau, the SQL code works wonderfully.
Thanks a lot
Sabine