Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

How to link two queries using fields from different tables (2nd Post)

edited May 2009 in DADE
Hi,

I bought and installed the new version, but I can't find a solution to my
problem that was:

In a report built with an "enduser solution", I need to create a query (QA)
and link it to another (QB) with two fields.
In both queries I have two fields from different tables.
RBuilder let me link from QA using only the fields that come the first table
in the query (the root):
I can choose any field in QB, but in QA only those that come from the
root table.

I cannot avoid this because of the logic of the report.
How can I solve this?

I tried to modify manually the SQL (with Edit SQL), but I lost all links and
I don't know how to set them.
How can I set them?
Can I use query params and use them as I do in VCL for Master/Details?

I tried new features but I think they're not enough.
I'd like to create datasets from Rap end set their parameters too, how can I
do It?

Can you help me please?
Thank you in advance.

Massimiliano Trezzi.

Comments

  • edited May 2009
    Sorry, I did not see your follow up post to the prior thread.

    The Linking issue is being researched and I will post a follow up here.

    From RAP you can use TdaSQLBuilder to modify the SQL associated with a
    QueryDataView. See TdaSQLBuilder topic in the RBuilder help and the
    following section of rbWiki

    http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder

    If you need to create entirely new QueryDataViews via RAP code, then you
    will need to extend RAP with some custom pass-thru functions. This rbWiki
    example shows to create new QueryDataViews via Delphi code

    http://www.digital-metaphors.com/rbWiki/DADE/Program_Control/How_To...Create_Query_DataViews_via_Code

    There are tutorials in the Developers Guide about extending RAP with custom
    functions.


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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2009

    There is now an RB 11.04 patch available to address the linking issues.
    Registered RB 11.04 customers can email support@digital-metaphors.com and
    request the patch.


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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2009
    Ok it works.

    Thanks You.

  • edited June 2009
    Hi,
    is this patch included in RB 11.05

    Thank you,
    Massimiliano Trezzi

  • edited June 2009
    Yes.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.