I'm playing with several things at once, including PDO:firebird in php,
but I think I've tracked the source of my problem to a strange result
from this query

SELECT 'INDI' AS type, COUNT(*) AS num FROM pgv_individuals WHERE i_file=1
UNION ALL
SELECT 'FAM' AS type, COUNT(*) AS num FROM pgv_families WHERE f_file=1
UNION ALL
SELECT 'NOTE' AS type, COUNT(*) AS num FROM pgv_other WHERE o_file=1
UNION ALL
SELECT 'SOUR' AS type, COUNT(*) AS num FROM pgv_sources WHERE s_file=1
UNION ALL
SELECT 'OBJE' AS type, COUNT(*) AS num FROM pgv_media WHERE m_gedfile=1
GROUP BY type

I'm only getting 4 results rather than the 5 expected, and strapping a
SELECT type, num FROM () around it does not help.

I know this could be done other ways, but the problem is that this is
working with other databases in PHP/PDO. PDO:firebird simply crashes
apache when it trys to fetch even the first result! But the first
problem is to sort out why the SQL fails - in FB2.1.3

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php