Thanks Martijn, I thought as much.
Norman

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, January 27, 2009 1:23 PM
Subject: Re: [firebird-support] Insert into ... select ... from


> 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
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>


--------------------------------------------------------------------------------



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.14/1917 - Release Date: 1/26/2009
6:37 PM