Subject | RE: [firebird-support] Re: CR/LF in SQL |
---|---|
Author | Alan McDonald |
Post date | 2004-06-22T12:51:05Z |
> char sel_str []=but I get a sneeking suspicion that he wants data to be returned in one
> "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
>
column rather than as rows a la ISQL data returns...
surely I'm wrong
Alan