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

rbuser

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.

nardmoseley

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

nardmoseley

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

rbuser

Ok it works.

Thanks You.

rbuser

Hi,
is this patch included in RB 11.05

Thank you,
Massimiliano Trezzi

nicocizik

Yes.

--
Regards,

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