|
| Iniciado por Kuiper WIM ( Kuiper, 25,nov. 2015 16:39 - No hay respuesta |
| |
| | | |
|
| |
Miembro registrado
3 mensajes |
|
| Publicado el 25,noviembre 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. |
| |
| |
| | | |
|
| | | | |
| | |
|