> > How did the CR and LF characters get in there? How are you
> setting the SQL
> > property?
>
> CR and LF characters are standard line-breaking characters in
> Windows text (strings of a multi-line control).
> They are being put in there by TIB_Query component itself, more
> precisely, by its embedded TStrings object (SQL property): "When
> reading Text, the strings in the list will be separated by

carriage

> return and line feed" (from Delphi online help).
> TIB_Query should have parse TStrings properly, but it looks as it
> doesn't.

...in some cases (which ones?).

To clarify a little bit more, and to answer the question asked - I
set SQL property at design time in this case. However, even if you
do that at run time by SQL.Append or something like that, SQL.Text
will contain CR+LF.

D.P.