fpsql documentation

[Brian K. White]

Kenneth Brody wrote:
> Brian K. White wrote:
>> Is there any documentation on fpsql other than the .hlp file?
>>
>> One of our developers is using fpsql to read filepro data from php.
>> As far as I can tell the only ways for the user to know how to parse the
>> fixed length output that fpsql returns is to
> [...]
>
> Try adding a delimiter between fields in the SELECT clause.
>
> select last_name, '|', first_name, '|', phone
> from clients

Awsome I'll present it.
Actually I beleive he reads this list but it's another thing for us to
consider.
Actually I thought of that too just talking on the phone originally but
at the time I had no idea it was that simple to do
Thanks much.

Another idea I just had was instead of having no headers, or headers
every n lines, do two queries.
One query with headers and just get any old single record just to get
the header, followed by the real query with set lines 0.
I like the delimiters though. I know it's painless to import and explode
that in php
.
-- 
bkw