G'day,

Is there a way to get more than 30 characters in the fieldname
returned from a SELECT query?

I'm running into this limitation using queries built from both
IBExpert and within PHP and it's ADOdb abstraction library.

The queries are executing okay, it's just the result set fieldname
that is being truncated to 30 chars.

Hopefully there a config option for this somewhere? Bueller?

Have checked docs and google with no luck so far.

Am using Firebird 1.5 RC8 on WinXP with latest patches,
but will also be running on Linux in production.

You may be asking yourself why is this nutter using so many
characters in a fieldname...well...the answer is thus: I've written
an automation layer on top of the PHP ADOdb abstraction library,
and since there isn't a reliable mechanism for obtaining both the
table name and field name metadata across the dozen or so
databases that ADOdb support, what I do is pre-process queries
to combine both the table name and field name into a field alias,
using a unique separator. Then after the query is run, post-process
to remove the alias an thus obtaining table and field name with no
need for meta-data at all. e.g.

SELECT table.field table__alias__field FROM table

If you're still wondering why this is necessary, the software is designed
for Flash shockwave clients, so the results have to be sent from the
server (typically as XML)

It's all open source if you want to have a squizz:
http://flashpash.sshnug.com <http://flashpash.sshnug.com>

Thanks for any help...sorry for such a long first post!

peace
si