Página 1 de 1

Character length limit on TSQLQuery:cSelect?

Publicado: Vie Nov 30, 2007 12:54 am
por Mahanimann
I get the following error when compiling with a TSQLQuery:cSelect which is
2360 characters long:
frm_Kunder.xfm (23) Error E0030 Syntax error: "parse error at 'OUTER'"
Line #23 is where the WITH oDataSet .... :cSelect is initiated in the .XFM
file.
The "'OUTER'" word changes when I change the SQL statement. The common
thing is that the word ALLWAYS is around character number 2050. To me this
indicates a read length limit when parsing the :cSelect property. Is it so?
If so, why and/or what can we do about it? If not so, any suggestions on
how to deal with this?
There are no spaces or non-english letters, and therefore no quotemarks
around field- and tablenames, i.e. the query is very plain even if it has
some length. It runs fine in all other SQL editors I have installed (and
that is quite a few). I do use underscore as the first letter in field
aliases (example: CONCAT(t.Number,' ',t.Name) AS _Number_Name), but this
works fine in other shorter SQL statements (in Xailer).
I use v1.66, TMySQLDataSet and TSQLQuery.
Regards,
Paal