Hi group,
Am I correct in saying that this syntax will work within the same database, but will fail if the source table is in a different Firebird database to one containing the destination table?

Insert into Clients select FirstName, Surname, Initials from NewEnquiries

will work fine, but

Insert into Clients select FirstName, Surname, Initials from OtherDB.NewEnquiries

whereas the above will fail.

Regards,
Norman

[Non-text portions of this message have been removed]