rcFetch in 2008.3

[Mihir Mihir]

rcFetch in 2008.3

Hello,

We upgraded our production environment to 2008.3 in last Nov. A few of our forms use composite queries in rcFetch function, example:

rcFetch('Q1:M1, Q2:M2','Q1PL=P1&Q2PL=P2|P3|@Q1.R1')

where,

Q1 = 1st SQL query,

Q2 = 2n SQL query,

M1,M2: mappings,

P# = params passed to SQL queries,  AND

@Q1.R1 = result of 1st query passed as param to 2nd query

This syntax was working fine in our old production box - nS 2006.0.8 but this doesn't seem to work in 2008.3.

Can anyone please help in advising if this syntax still holds true in 2008.3 or are there any other new ways to do this operation using nS 2008.3 features?

Thank You,

Mihir

[Scott Stauffer]

We ran into the same problem when upgrading from 2006.6 to 2008.3.  The problem occurs when you try to pass a value returned from the 1st query as a parameter to the 2nd query.  To workaround this issue, we moved the 2nd query into a data callback function that runs after the first query is complete.  For example, here is our original function that contained a composite query:

function siteRC_REQUESTEDFOR_onLoad() {
 rcFetch("Q2A:M2,Q2B:M3", "Q2APL=" + ReqCustomerID + "Q2BPL=@

[Mihir Mihir]

Thanks a lot, Scott! It helped!

Thanks,

Mihir