Hi,

> 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

Correct.

> Insert into Clients select FirstName, Surname, Initials from
> OtherDB.NewEnquiries
>
> whereas the above will fail.

Correct.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com