If you are using delphi you can use two TQuery (or TTable) component and one TBatchRecord (I don't remember exactly the name) component. If you take a look at that component you will see that it has a "source" and a "dest", well as source you should refer to your source table and "dest" you destination table. Take in mind that both the queries has to be open. To starting up copying data do MyBatch.execute;
BR
Antonio
probably I mistake some name or properties, but please follow only the idea
column@... wrote:So, what I should put in IBSQL1.Database property then? First database ore
second?

----- Original Message -----
From: "Alan McDonald"
To:
Sent: Tuesday, November 12, 2002 12:00 PM
Subject: RE: [ib-support] select from one_database.table into
another_database.table


> no, just put that SQL i mentioned into an IBSQL component and execute it
> Alan
>
> > -----Original Message-----
> > From: column@... [mailto:column@...]
> > Sent: Tuesday, 12 November 2002 21:51
> > To: ib-support@yahoogroups.com
> > Subject: Re: [ib-support] select from one_database.table into
> > another_database.table
> >
> >
> > Thank you for support.
> >
> > Regarding IBSQL. What is the way of using it?
> >
> > Should I :
> > connect to first_database
> > do select from first_database
> > connect to second_database
> > do insert to second_database?
> >
> > ----- Original Message -----
> > From: "Alan McDonald"
> > To:
> > Sent: Tuesday, November 12, 2002 10:00 AM
> > Subject: RE: [ib-support] select from one_database.table into
> > another_database.table
> >
> >
> > > Sorry - I didn't note the reference to SP... You'll be able to use the
> > IBSQL
> > > component
> > > Alan
> > >
> > > > -----Original Message-----
> > > > From: column@... [mailto:column@...]
> > > > Sent: Tuesday, 12 November 2002 19:45
> > > > To: ib-support@yahoogroups.com
> > > > Subject: [ib-support] select from one_database.table into
> > > > another_database.table
> > > >
> > > >
> > > > Hi,
> > > >
> > > >
> > > >
> > > > I need to do this action:
> > > >
> > > > Select from one_database.table into another_database.table
> > > >
> > > >
> > > >
> > > > Is it possible to do this with stored procedure?
> > > >
> > > >
> > > >
> > > > If no then is it possible to do wit IBX components? If yes then
> > > > what is the
> > > > best way to do that?
> > > >
> > > >
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > ib-support-unsubscribe@egroups.com
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




---------------------------------
Per te Blu American Express è gratis

[Non-text portions of this message have been removed]