Subject | RE: [IBO] Datapump auto DstLinks question - how to get column names? |
---|---|
Author | Jung |
Post date | 2002-10-01T22:30:34Z |
Now that I can't get the datapump component to provide auto DstLinks, I am
going to construct the links myself. I have spend the last 30 minutes
looking at the Help file trying to get a list of column names for a
tib_cursor but haven't found a way to do it. I am sure it is pretty simple
but for some reason I can't figure out.
Perhaps you know...
Thanks
Jung
-----Original Message-----
From: Jung [mailto:jungv@...]
Sent: Tuesday, October 01, 2002 12:14 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Datapump auto DstLinks question
I have occasionally come across this problem where pumping data between
tables with same fields types and name, and the datapump component seemed to
not link them automatically. It got worse recently when I tried to pump
between two Firebird 1 databases.
I am not sure what is going on, but I did create two identical tables with
different names on two different databases. All the fields names and types
are the same on the two tables. Regardless what I use for my cursors, select
* or select fields names, if I didn't provide the DstLinks, the pump failed.
Same statements works in IB_SQL.exe without explicit DstLinks (generated
automatically after the pump). I must be missing something.
Thanks for any pointer,
Jung
-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Tuesday, October 01, 2002 9:16 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Datapump auto DstLinks question
It does it automatically if they are the same.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
going to construct the links myself. I have spend the last 30 minutes
looking at the Help file trying to get a list of column names for a
tib_cursor but haven't found a way to do it. I am sure it is pretty simple
but for some reason I can't figure out.
Perhaps you know...
Thanks
Jung
-----Original Message-----
From: Jung [mailto:jungv@...]
Sent: Tuesday, October 01, 2002 12:14 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Datapump auto DstLinks question
>It does it automatically if they are the same.Apparently that is not always the case and it is driving me nut. In the past
I have occasionally come across this problem where pumping data between
tables with same fields types and name, and the datapump component seemed to
not link them automatically. It got worse recently when I tried to pump
between two Firebird 1 databases.
I am not sure what is going on, but I did create two identical tables with
different names on two different databases. All the fields names and types
are the same on the two tables. Regardless what I use for my cursors, select
* or select fields names, if I didn't provide the DstLinks, the pump failed.
Same statements works in IB_SQL.exe without explicit DstLinks (generated
automatically after the pump). I must be missing something.
Thanks for any pointer,
Jung
-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Tuesday, October 01, 2002 9:16 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Datapump auto DstLinks question
It does it automatically if they are the same.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
----- Original Message -----
From: "Jung" <jungv@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, October 01, 2002 2:47 AM
Subject: [IBO] Datapump auto DstLinks question
> I am writing a scriptable datapump program to work with two abitrary
cursors
> having same field names for source and destination. Is there an easy way
to
> tell the datapump component to automatically generate links by matching
> names of source and destination fields?
>
> Thanks.
>
> Jung
Yahoo! Groups Sponsor
ADVERTISEMENT
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/