Pipeline link crash with oracle

rbuser

Hi,

I have a end user application (Delphi 5) using DADE ReportBuilder 7.0 with
DOA.
I tried to make a link between two datapipeline the first one contains two
tables with two columns with the same name.
The second one contains 1 table with 1 column this column allows to make the
link between datapipelines.


It seems that when you have a MasterPipeline with twice the same column name
coming from two different tables (even if it's not selected in the fields
sheet) and the DetailPipeline uses this column to make the link, the sql
generated by DADE is wrong.

When I try to use the DetailPipeline it crashes with error ora-00936:
missing expression.
The request send to the oracle server looks like: SELECT .... FROM
TABLE1,TABLE2,TABLE3 WHERE TABLE1.COLULMN1 = TABLE2.COLUMN1 AND ORDER BY
....

(When pipelines are not linked they work fine)

Any ideas ?

Thanks

digitalmetaphors

So it should be WHERE TABLE1.COLULMN1 = TABLE2.COLUMN2. We have fixed a
couple of issues related to DADE linking since the initial release of RB
7.00. The first thing to try is to download RB 7.02 Build 2 and test with
this latest release.


Cheers,

Jim Bennett
Digital Metaphors