Hi,

> Please help me with syntax to Insert rows from table in other database:
>
> INSERT INTO "customer.gdb".table
> FROM "192.168.1.1:c:\oldcustomer.gdb".table
> Where Name = 'David'

This isn't possible with a pure SQL statement.

But, you might be able to do that within your client
application by using the two-phase commit (2PC) protocol.

Perhaps your data access components offer something
like a data pump component (e.g. IBObject does). If
it is a one time job to move records between databases,
then grep of the available third-party tools.

InterBase DataPump is one of them.
http://www.clevercomponents.com/products/datapump/ibdatapump.asp

Database Workbench has a pump facility too.
http://www.upscene.com



HTH,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com