Subject Re: CR/LF in SQL
Author peter_jacobi.rm
Hi Christian,

Christian Gütter <news@g...> wrote:
> I think you misunderstood my question. It was about
> receiving data, not about sending data to the server.

But you *are* sending data to the server: the DSQL string.

Hacking in the example program api3.c, I changed the query to:

char sel_str []=
"SELECT last_name || '\x0d\x0a' || first_name, phone_ext
FROM phone_list \
WHERE location = 'Monterey' ORDER BY last_name, first_name;";

And it works as expected. So you can use the Delphi mechanism
to put the CR/LF into the SELECT clause, and the matching
characters will be returned by FB.

Regards,
Peter Jacobi