|
| ODBC SQL Query (5.5 mode) Windev 20 |
| Iniciado por Kuiper WIM ( Kuiper, 17,ene. 2016 19:38 - No hay respuesta |
| |
| | | |
|
| |
Miembro registrado
3 mensajes |
|
| Publicado el 17,enero 2016 - 19:38 |
Hello:
I use ODBC SQL Query (5.5mode) in Windev 19 in Report for a selection analyse from MariaDb database-> see sample.
Now in Windev 20 when make a new Report ther isn't a ODBC SQL Query (5.5 mode) any more.
How to solve my needed selection for report in Windev 20??
SELECT
qfsprmen.BIB,
qfsprmen.Time,
qfsprmen.License,
qfsprmen.MM,
qfsprmen.M,
qfsprmen.LASTNAME,
qfsprmen.FIRTSNAME,
qfsprmen.Country,
qfsprmen.Speed,
FIND_IN_SET( MM, (
SELECT GROUP_CONCAT( MM
ORDER BY MM ASC )
FROM qfsprmen )
) AS R ,
FIND_IN_SET( TIME, (
SELECT GROUP_CONCAT( TIME
ORDER BY TIME ASC )
FROM qfsprmen )
) AS R1
FROM qfsprmen
order by -Time DESC |
| |
| |
| | | |
|
| | | | |
| | |
|