----- Original Message -----
From: "Nic Wise" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi"
<[EMAIL PROTECTED]>
Sent: Monday, September 03, 2001 10:23
AM
Subject: Re: [DUG]: Accessing mulltiple Interbase
databases
> Mike,
>
> are you doing this thru something BDE-specific? or is it going direct to
> interbase?
>
>
> are you doing this thru something BDE-specific? or is it going direct to
> interbase?
>
Yes - I'm intending (trying) to do
this via the BDE.
I keep getting syntax errors on the
colon defining the alias name - same in Database Explorer, Database Desktop,
TQuery.SQL
> 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
This is ad hoc activity - not part of
system - but faster than manually!!
>
> If its just a once off thing, try using the datapump :)
Hadn't thought of that - I've tried
it - it's working for some tables and not for others. Can't see why some aren't
working - columns map corrrectly.
Any ideas?
>
> 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/
>
