pcsoft.us.windevCopyright 2026, PC SOFT16 Feb 2015 19:46:00 Z15 Feb 2015 12:46:00 ZHi I need to select which field to sort by, by passing a parameter. Is this possible? If a query has two fields ( code and description), sometimes I need to sort by code some times by descrtiption. Do I need to create two queries? I cannot use an array as this query is going into an array of structures and arraysort does not work. Thank Noel30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50513/read.awp16 Feb 2015 19:46:00 ZQuote Arie Mars Noel, you can provide the "sort" you need as a parameter. Just like where-parameters. If you open the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50513/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50513/read.awpWD19 - Query Sortguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50491/read.awp15 Feb 2015 14:17:00 ZThanks. will try the sort on parameterhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50491/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50491/read.awpWD19 - Query Sortguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50490/read.awp15 Feb 2015 13:09:00 ZNoel, you can provide the "sort" you need as a parameter. Just like where-parameters. If you open the queyr in the designer, j…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50490/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50490/read.awpWD19 - Query Sortguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50489/read.awp15 Feb 2015 13:05:00 Zhi Noel Yes you can edit the query and set the sort as a parameter SELECT * FROM Table WHERE table.field1 = {pField1} …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50489/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50486-wd19-query-sort-50489/read.awpWD19 - Query Sort