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/
