Hi Set,

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

Ehm... Right. I left that as an exercise to the reader. :-)

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

I do think so.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com