Hi Martijn! Have you been working too much with other databases lately
or is this yet another thing to blame on the broken part of your body?

--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:
> INSERT INTO master (ID, Name, Town) VALUES
> SELECT 'ID2', Name, Town
> WHERE ID = 'ID1';

Try changing this to

INSERT INTO master (ID, Name, Town)
SELECT 'ID2', M2.Name, M2.Town
FROM master M2
WHERE M2.ID = 'ID1';

(i.e. remove VALUES and add the table once more).

Set
-I didn't think Martijn were having a Bamsemums crisis just yet...