Geoff,

This might be a stupid reply, because the subject is way deeper than my
knowlege/abilities, but :

>> The difficulty is that this has to be done before the prepare (so that
>> the field can be added if necessary). Which is a pity, because after
>> prepare we have an ready list of column names to scan :-(

How about creating a second copy of query and preparing it, then scan the
column names from that, then unprepare it etc.
I presume this would add some overhead to the process, but it is just a
suggestion.

(Be gentle with me !)

Regards,
Norman.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------


This email is intended only for the use of the addressees named above and
may be confidential or legally privileged. If you are not an addressee you
must not read it and must not use any information contained in it, nor copy
it, nor inform any person other than Lynx Financial Systems or the
addressees of its existence or contents. If you have received this email
and are not a named addressee, please delete it and notify the Lynx
Financial Systems IT Department on 0113 2892990.