Finally figured it out ...DataSet.Fields[i].FieldName.

My next problem is to find an appropriate event in the datapump component to
fire off the code that set DstLinks. I am looking for an event that happens
after the fields names are retrieved for both the source dataset and the
destination statement but before the pumping start. Any pointer is
appreciated.

Jung

-----Original Message-----
From: Jung [mailto:jungv@...]
Sent: Tuesday, October 01, 2002 3:31 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Datapump auto DstLinks question - how to get column
names?


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

>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/




___________________________________________________________________________
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/