PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → hQueryWithoutCorrection does not transfer MySql-text fields
hQueryWithoutCorrection does not transfer MySql-text fields
Iniciado por Pascal Scheffers, 12,jul. 2004 15:45 - No hay respuesta
Publicado el 12,julio 2004 - 15:45
I have a mysql query which uses an outer join. HExecuteSQLQuery does not like the words 'outer' or 'left', so I need to run this query with hQueryWithoutCorrection.
Unfortunately, this means that fields of type 'text' do not get transfered to the resulting 'data source'. Is this a bug or a feature? Feels like a bug to me, but I might be missing something. The only work arounds I are rather tedious (hand joining to queries...) and very inefficient.
Does anyone know how to fix this ?