Dynamic Query Question

Yahoo Archive
1
You don't need to. The whereItems are all just stored in order. The easiest
way is to just pop a little message box to see which is which.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Fri, Jul 20, 2012 at 10:25 AM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> I am curious if there is a way using DynamicQuery to specify which table
> in a BAQ receives which data to satisfy criteria.
>
> For example, I have two tables in a BAQ each have criteria on them. How
> would i specify the criteria for table 1 is the job number and table 2
> needs a criteria for part number?
>
> This is what I have been using, haven't been able to figure out how to say
> which table and then use QueryWhereItem(0).
>
> _baqQueryDS.QueryWhereItem(0).RValue = txtJobNum.Text
>
> Thanks,
>
> -Ted
>
>
>


[Non-text portions of this message have been removed]
2
I am curious if there is a way using DynamicQuery to specify which table in a BAQ receives which data to satisfy criteria.

For example, I have two tables in a BAQ each have criteria on them. How would i specify the criteria for table 1 is the job number and table 2 needs a criteria for part number?

This is what I have been using, haven't been able to figure out how to say which table and then use QueryWhereItem(0).

_baqQueryDS.QueryWhereItem(0).RValue = txtJobNum.Text

Thanks,

-Ted