<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>17 Jan 2016 19:38:58 Z</lastBuildDate><pubDate>17 Jan 2016 19:38:58 Z</pubDate><description>Hello:&#13;
I use ODBC SQL Query (5.5mode) in Windev 19 in Report for a selection analyse from MariaDb database-&gt; see sample.&#13;
&#13;
&#13;
Now in Windev 20 when make a new Report ther isn't a ODBC SQL Query (5.5 mode) any more.&#13;
&#13;
How to solve my needed selection for report in Windev 20??&#13;
&#13;
&#13;
&#13;
SELECT&#13;
qfsprmen.BIB,&#13;
qfsprmen.Time,&#13;
qfsprmen.License,&#13;
qfsprmen.MM,&#13;
qfsprmen.M,&#13;
qfsprmen.LASTNAME,&#13;
qfsprmen.FIRTSNAME,&#13;
qfsprmen.Country,&#13;
qfsprmen.Speed,&#13;
FIND_IN_SET( MM, (&#13;
SELECT GROUP_CONCAT( MM&#13;
ORDER BY MM ASC ) &#13;
FROM qfsprmen )&#13;
) AS R ,&#13;
FIND_IN_SET( TIME, (&#13;
SELECT GROUP_CONCAT( TIME&#13;
ORDER BY TIME ASC ) &#13;
FROM qfsprmen )&#13;
) AS R1&#13;
FROM qfsprmen&#13;
 order by -Time DESC</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55894-odbc-sql-query-5-5-mode-windev/read.awp</link><title>ODBC SQL Query  (5.5 mode) Windev 20</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster></channel></rss>
