Mike, are you doing this thru something BDE-specific? or is it going direct to interbase? I'm not sure if IB support hetrogenious use of databases (I thought I saw reference in the help file once, but I can't find it anymore), but the BDE will do it, pretty much as you showed below..... I doubt its going to be quick tho If its just a once off thing, try using the datapump :) Nic. ----- Original Message ----- From: "Mike Osborne" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Monday, September 03, 2001 9:59 AM Subject: [DUG]: Accessing mulltiple Interbase databases > I have two Interbase databases - same structure. > > I want to append records from a table in one database into the other. > > I write - > > insert into mytable select * from :otherdb:mytable > > but the SQL will not run as it doesn't seem to allow the alias definition > in the prefix. > > I've tried batch moves - they don't work either. > > How can I append records across Interbase databases? > > TIA > Mike > > > -------------------------------------------------------------------------- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
