BAQ-Nonstock flags

Yahoo Archive
1
If they are not related internally, you might have to specify the join in
the table relation dialog.
Carey


>From: "ermc_v" <rjohnson@...>
>Reply-To: vantage@yahoogroups.com
>To: vantage@yahoogroups.com
>Subject: [Vantage] Re: BAQ-Nonstock flags
>Date: Wed, 10 Jan 2007 20:32:19 -0000
>
>I tried that but I either get ALL PART RECORDS or NONE. It does not
>appear that you can compare flags from two separate tables in this
>way.
>
>--- In vantage@yahoogroups.com, "laidig.systems"
><laidig.systems@...> wrote:
> >
> > I don't know about Vista, but in Vantage you can create a filter
>that
> > says Part.Nonstock <> PartPlant.Nonstock in the BAQ phrase
>builder.
> > You have to uncheck the "isConst" box to unlock the "toTable" and
> > "toField" inputs.
> >
> >
> > --- In vantage@yahoogroups.com, "ermc_v" <rjohnson@> wrote:
> > >
> > > I think I've tried something similar to this before but could
>not get
> > > it to work. I am trying to create a watchdog BAQ to find part
>records
> > > where the Part.Nonstock <> PartPlant.Nonstock.
> > >
> > > I can filter by looking at records where Part.Nonstock=TRUE AND
> > > PartPlant.Nonstock=FALSE. I can also filter by looking for
>records
> > > where Part.Nonstock=FALSE AND PartPlant.Nonstock=TRUE.
> > > However, I have been unable to combine these. I also tried a
>direct
> > > comparison: Where Part.Nonstock <> PartPlant.Nonstock, to no
>avail.
> > >
> > > I would like to avoid using 2 separate BAQ's for this item. Any
> > > suggestions?
> > > Vista 8.0
> > >
> >
>
>

_________________________________________________________________
Find sales, coupons, and free shipping, all in one place! �MSN Shopping
Sales & Deals
http://shopping.msn.com/content/shp/?ctid=198,ptnrid=176,ptnrdata=200639
2
I think I've tried something similar to this before but could not get
it to work. I am trying to create a watchdog BAQ to find part records
where the Part.Nonstock <> PartPlant.Nonstock.

I can filter by looking at records where Part.Nonstock=TRUE AND
PartPlant.Nonstock=FALSE. I can also filter by looking for records
where Part.Nonstock=FALSE AND PartPlant.Nonstock=TRUE.
However, I have been unable to combine these. I also tried a direct
comparison: Where Part.Nonstock <> PartPlant.Nonstock, to no avail.

I would like to avoid using 2 separate BAQ's for this item. Any
suggestions?
Vista 8.0
3
I don't know about Vista, but in Vantage you can create a filter that
says Part.Nonstock <> PartPlant.Nonstock in the BAQ phrase builder.
You have to uncheck the "isConst" box to unlock the "toTable" and
"toField" inputs.


--- In vantage@yahoogroups.com, "ermc_v" <rjohnson@...> wrote:
>
> I think I've tried something similar to this before but could not get
> it to work. I am trying to create a watchdog BAQ to find part records
> where the Part.Nonstock <> PartPlant.Nonstock.
>
> I can filter by looking at records where Part.Nonstock=TRUE AND
> PartPlant.Nonstock=FALSE. I can also filter by looking for records
> where Part.Nonstock=FALSE AND PartPlant.Nonstock=TRUE.
> However, I have been unable to combine these. I also tried a direct
> comparison: Where Part.Nonstock <> PartPlant.Nonstock, to no avail.
>
> I would like to avoid using 2 separate BAQ's for this item. Any
> suggestions?
> Vista 8.0
>
4
I tried that but I either get ALL PART RECORDS or NONE. It does not
appear that you can compare flags from two separate tables in this
way.

--- In vantage@yahoogroups.com, "laidig.systems"
<laidig.systems@...> wrote:
>
> I don't know about Vista, but in Vantage you can create a filter
that
> says Part.Nonstock <> PartPlant.Nonstock in the BAQ phrase
builder.
> You have to uncheck the "isConst" box to unlock the "toTable" and
> "toField" inputs.
>
>
> --- In vantage@yahoogroups.com, "ermc_v" <rjohnson@> wrote:
> >
> > I think I've tried something similar to this before but could
not get
> > it to work. I am trying to create a watchdog BAQ to find part
records
> > where the Part.Nonstock <> PartPlant.Nonstock.
> >
> > I can filter by looking at records where Part.Nonstock=TRUE AND
> > PartPlant.Nonstock=FALSE. I can also filter by looking for
records
> > where Part.Nonstock=FALSE AND PartPlant.Nonstock=TRUE.
> > However, I have been unable to combine these. I also tried a
direct
> > comparison: Where Part.Nonstock <> PartPlant.Nonstock, to no
avail.
> >
> > I would like to avoid using 2 separate BAQ's for this item. Any
> > suggestions?
> > Vista 8.0
> >
>