https://foro.gambas-es.org/viewtopic.php?f=3&t=6231&p=37291#p37291
-----------------------------------
jsbsan
Miercoles, 15 Marzo 2017, 11:11

Re: Tener Un Registro De Varios Registros
-----------------------------------
Pregunta ¿funciona con sqlite?

A mi me da errores:
[quote]SQLiteManager: Likely SQL syntax error: SELECT DISTINCT ES2.indx, 
    SUBSTRING(
        (
            SELECT ':'+ES1.nombre  AS [text()]
            FROM estudiantes ES1
            WHERE ES1.indx = ES2.indx
            ORDER BY ES1.indx
            FOR XML PATH ('')
        ), 2, 1000) [estudiantes]
FROM estudiantes ES2 [ near "FOR": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement][/quote]


