Join fields between SQL-Edited data pipelines
Hi
I?d like to know if it?s possible to drag a primary-key field from one data
pipeline to another one (the foreign-key field in this one). However, this
second data pipeline has a special SQL sentence (... I mean, when you edit
the SQL manually, you loose all those tabs). I found out that in this case
it?s impossible to join those 2 data pipelines! (Am I wrong?)
Thanks in advance,
Marcelo
I?d like to know if it?s possible to drag a primary-key field from one data
pipeline to another one (the foreign-key field in this one). However, this
second data pipeline has a special SQL sentence (... I mean, when you edit
the SQL manually, you loose all those tabs). I found out that in this case
it?s impossible to join those 2 data pipelines! (Am I wrong?)
Thanks in advance,
Marcelo
This discussion has been closed.
Comments
It is possible to join two datapipelines in code when you have edited the
sql in DADE. Follow the link below for an example of how this is done.
http://www.digital-metaphors.com/tips/LinkEditSQLDatviews.zip
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com