Query on many to many relationschips

Posted by Wim on 04-Sep-2015 08:04

Hello,

Im a trying to do a query in an n to n relationship using:

v_result = rbv_api.selectQuery2("SELECT discounta_sellpercentage, R_discount_tyrelabel,R_discount_rimdiameter FROM discount " +
"WHERE R_discount_condition = ?" +
"AND R_discount_customers = ? " +
"AND R_discount_isocountry = ? " +
"AND R_discount_pricecategory = ? " +
"AND R_discount_rategroup = ? " +
"AND R_discount_contracttype = ? " +
"AND R_discount_application = ? " +
"AND R_discount_applicationtask = ? " +
"AND R_discount_tyrelabel IN (SELECT id FROM tyrelabel where R_tyrelabel_discount = ?) " +
"AND R_discount_seasonappliance = ?" +
"AND R_discount_tyrebrand = ?" +
"AND R_discount_tyretotransporttype = ?" +
"AND R_discount_rimdiameter = ?", 0, 10, v_conditionid, v_customerid, v_isocountryid, v_pricecategoryid, v_rategroupid, v_contracttypeid, v_applicationid, v_applicationtaskid, v_tyrelabelid, v_seasonid, v_tyrebrandid, v_transporttypeid, v_rimdiameterid);

The IN (SELECT gives an error. 

Can anyone help?

Posted by Anoop Premachandran on 05-Sep-2015 00:35

We don't support sub queries in Rollbase SelectQuery.

Please see this link for supported syntax - documentation.progress.com/.../index.html

All Replies

Posted by Anoop Premachandran on 05-Sep-2015 00:35

We don't support sub queries in Rollbase SelectQuery.

Please see this link for supported syntax - documentation.progress.com/.../index.html

Posted by Wim on 07-Sep-2015 01:16
Thanks for information, we will try with LOOP_BEGIN, etc


Verstuurd vanaf mijn iPhone

Op 5 sep. 2015 om 07:35 heeft Anoop Premachandran <bounce-apremach@community.progress.com> het volgende geschreven:

Reply by Anoop Premachandran

We don't support sub queries in Rollbase SelectQuery.

Please see this link for supported syntax - documentation.progress.com/.../index.html

Stop receiving emails on this subject.

Flag this post as spam/abuse.

This thread is closed