PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Windev Report SQL
Windev Report SQL
Débuté par Kuiper WIM ( Kuiper, 25 nov. 2015 16:39 - Aucune réponse
#1
Membre enregistré
3 messages
Posté le 25 novembre 2015 - 16:39
Hello,
I Use Windev 20.

I like to use SQL instruction "FIND in SET" for rangking some items in my report.

Now it is only working in the ODBC Query 5.5 mode??.


I want use it in a query off the project for HFSQL .

How to do it?.



Here my Sample Code:

FIND_IN_SET(M, (
SELECT GROUP_CONCAT(M
ORDER BY M ASC )
FROM pursuitwom12 )
) AS R1 ,
FIND_IN_SET(MM, (
SELECT GROUP_CONCAT(MM
ORDER BY MM ASC )
FROM pursuitwom12 )
) AS R2
FROM pursuitwom12, status where print="P" AND Status.StId = Category
ORDER BY MMM ASC

Regards,
WIm Kuiper.
→ Revenir à WINDEV 2024