Svein Erling Tysvær wrote:

> Do you get the same strange result if you use AS "TYPE" or AS pgv_type rather than AS type, Lester? I know that we were bitten by TYPE becoming a reserved word in IB6 or Fb1, though we simply changed to another field name and I haven't checked whether it has been removed from the reserved words since then.

In the end it was just 'finger trouble' SET
The SQL was actually correct, but the PDO driver simply can't handle
some types of SQL :(
I'm back with ADOdb now - that was a lot less work than trying to debug
yet another set of code :)

--
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