RB11.05: linking user defined query -> SQL error

rbuser

Hello,

I have two datapipelines, one with a manual SQL-statement (PL1) and the
other build with the SQL Builder (PL2).
Linking these datapipelines is only possible, when PL1 is the master and PL2
the detail.

Otherwise, I get an SQL error (unexcepted token: WHERE).
The problem is, that report builder attach a where clause to the manual
SQL-statement, which
already has a where clause.

How can I solve this problem?


Lars Hirthe

nardmoseley

Access the Link dialog for the detail query. Then select the SQL tab of the
Link dialog.

Set the Link type to Manual SQL.

Note: Manual SQL requires that you write the SQL to select all of the detail
records needed for the report - and Order By the linking field(s).



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Great, it works!

(That was the first time, that I saw the SQL tab in the Link Dialog.)

Lars

nardmoseley

Yes, that is new for RB 11


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com