PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → hQueryWithoutCorrection does not transfer MySql-text fields
hQueryWithoutCorrection does not transfer MySql-text fields
Started by Pascal Scheffers, Jul., 12 2004 3:45 PM - No answer
Posted on July, 12 2004 - 3:45 PM
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 ?