At 04:45 AM 25/01/2012, IBO Support List wrote:

>Sorry I overlooked this issue until now.
>
>Perhaps you should send me a little sample app to look at?
>
>Have you told IBO the KeyRelation that the insert is to be based on?

Also, look at the SQL for your query. The statement you provided has not been valid in Firebird since v.1.0. At v.1.5 it would return warnings (which developers often ignore) and except only if there is an actual clash of column names; while, from v.2.0 onwards it will usually throw an exception, whether or not there is a name clash.

SELECT ET_NAME, EQUIPMENT.*
FROM EQUIPMENT
LEFT JOIN EQUIP_TYPES ON ET_ID = E_TYPE
ORDER BY LOWER(ET_NAME), LOWER(E_MAKE)

Just guessing here about the source of each data piece, but to give you the idea:

SELECT et.ET_NAME, e.*
FROM EQUIPMENT e
LEFT JOIN EQUIP_TYPES et ON et.ET_ID = e.E_TYPE
ORDER BY LOWER(et.ET_NAME), LOWER(e.E_MAKE)

Helen