Subject | Re: CR/LF in SQL |
---|---|
Author | peter_jacobi.rm |
Post date | 2004-06-22T12:43:20Z |
Hi Christian,
Christian Gütter <news@g...> wrote:
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
Christian Gütter <news@g...> wrote:
> I think you misunderstood my question. It was aboutBut you *are* sending data to the server: the DSQL string.
> receiving data, not about sending data to the server.
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