E10: DynamicQuery Example

Yahoo Archive
1
Hello,

Does anyone have example of code of executing a BAQ with parameters using the DynamicQueryAdapter.

My code seems to be correct but I’m obviously missing something because no rows are returning even though there are rows when I test the BAQ.
I’m testing in BL Tester and not getting any rows there either.

Here is what I have:

QueryExecutionDataSet execDS = dqaPOAlloc.GetQueryExecutionParametersByID("MATS-POAlloc-UD112");

execDS.Tables["ExecutionParameter"].Rows[0]["ParameterValue"] = edvPORel.dataView[edvPORel.Row]["PONum"].ToString() + "-" + edvPORel.dataView[edvPORel.Row]["POLine"].ToString() + "-" + edvPORel.dataView[edvPORel.Row]["PORelNum"].ToString();

dqaPOAlloc.ExecuteByID("MATS-POAlloc-UD112", execDS);




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:a16439.png@54c49c17.42a21fae]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




[Non-text portions of this message have been removed]
2

Search through the list a bit I've posted this example a few times for E10

On Apr 21, 2015 4:41 PM, "Joe Rojas jrojas@... [vantage]" <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Hello,


Does anyone have example of code of executing a BAQ with parameters using the DynamicQueryAdapter.

My code seems to be correct but I’m obviously missing something because no rows are returning even though there are rows when I test the BAQ.
I’m testing in BL Tester and not getting any rows there either.

Here is what I have:

QueryExecutionDataSet execDS = dqaPOAlloc.GetQueryExecutionParametersByID("MATS-POAlloc-UD112");

execDS.Tables["ExecutionParameter"].Rows[0]["ParameterValue"] = edvPORel.dataView[edvPORel.Row]["PONum"].ToString() + "-" + edvPORel.dataView[edvPORel.Row]["POLine"].ToString() + "-" + edvPORel.dataView[edvPORel.Row]["PORelNum"].ToString();

dqaPOAlloc.ExecuteByID("MATS-POAlloc-UD112", execDS);




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:a16439.png@54c49c17.42a21fae]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]

</div>
 


<div style="color:#fff;min-height:0;"></div>