Page 1 of 1

mysql (query with parameter master detail) ?

Posted: Tue Feb 22, 2011 3:00 pm
by abi
hai..

i use mysql adapter with mysql connector.
i try master detail with 2 datasource

sample code:
-- master
select idp,name from t1

--child
select idk,smr from t2 where idk=@idp

datasource on child have parameter @idp and expression with master.idp

then, i try preview -- on child datasource get empty data...

may you can help me?

thanks


mysql (query with parameter master detail) ?

Posted: Tue Feb 22, 2011 5:48 pm
by abi
problem solved..

thanks guys

mysql (query with parameter master detail) ?

Posted: Tue Feb 22, 2011 11:41 pm
by Andrew
Ok! Have a nice day!

mysql (query with parameter master detail) ?

Posted: Wed Feb 23, 2011 8:17 am
by abi
tips:
on child datasource make sure Reconnect on each row must set TRUE and cast your parameter if necessary

mysql (query with parameter master detail) ?

Posted: Wed Feb 23, 2011 8:26 am
by Alex K.
Hello,

Thank you for sharing your experience with other users. Have a nice day!