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
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Character length limit on TSQLQuery:cSelect?
-
- Mensajes: 216
- Registrado: Dom Sep 23, 2007 11:08 pm