Excellent job!
--- On Fri, 4/17/09, Randy Weber <rweber@...> wrote:
From: Randy Weber <rweber@...>
Subject: RE: [Vantage] Re: BAQ Null value convert to zero
To: vantage@yahoogroups.com
Date: Friday, April 17, 2009, 1:15 PM
I finally found something that worked. The ? did not work to my
surprise. I thought that "= ?" was the trick but no...
I had to trick it into getting what I want. This returned either the
actual onhand or zero: If PartBin.OnHandQty >=0 Or PartBin.OnHandQty <=0
Then PartBin.OnhandQty Else 0
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of brz_larson
Sent: Friday, April 17, 2009 7:28 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: BAQ Null value convert to zero
RE: [Vantage] Re: BAQ Null value convert to zero
I have tried the trick of using an UD field on the table that is not
used.
Try -
If PartBin.OnHandQty = PartBin.Character01 ....
Because if Character01 is not used it will be null.
Good luck
BRZ in Mpls--- In vantage@yahoogroups .com
<mailto:vantage% 40yahoogroups. com> , "bw2868bond" <bwalker@... > wrote:
>
> Would a calculated field work?
>
> myValue = 0 + PartBin.OnHandQty
>
>
> --- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ,
Robert Brown <robertb_versa@ > wrote:
> >
> >
> > The problem (with PartBin) is that there really is no record
(assuming you're using outer left join) when o/h hits zero - not that
there is a record and the field value is null.
> >
> > That is a puzzler... Progress isn't SQL (so "null" really isn't in
its vocab... "?" is the progress equiv of SQL "null" if I remember
right)...
> >
> > Try:
> >
> > If PartBin.OnHandQty = ? Then 0 Else PartBin.OnhandQty
> >
> > I'm at a loss if the BAQ editor chokes on that (or it just doesn't
work).
> >
> > Rob
> >
> > --- On Thu, 4/16/09, Randy Weber <rweber@> wrote:
> >
> > From: Randy Weber <rweber@>
> > Subject: RE: [Vantage] BAQ Null value convert to zero
> > To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> > Date: Thursday, April 16, 2009, 4:05 PM
> >
> >
> >
> >
> >
> >
> >
> >
> > Thanks for trying, but that didn't work. I still get a null result
when
> > I want zero.
> >
> > Randy Weber
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
> > Of Chris Thompson
> > Sent: Thursday, April 16, 2009 2:54 PM
> > To: vantage@yahoogroups .com
> > Subject: Re: [Vantage] BAQ Null value convert to zero
> >
> > Hi Randy,
> >
> > Try this...
> >
> > If PartBin.OnHandQty < 1 Then 0 Else PartBin.OnhandQty
> >
> > I don't know if it'll work but I found Null isnt recognised most of
the
> > time.
> >
> > Let me know how you get on.
> >
> > Cheers,
> >
> > CHRIS THOMPSON
> >
> > ____________ _________ _________ __
> > From: Randy <rweber@tlcelectron i cs.com
> > <mailto:rweber% 40tlcelectronics .com> >
> > To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> > Sent: Thursday, 16 April, 2009 20:16:53
> > Subject: [Vantage] BAQ Null value convert to zero
> >
> > I have a BAQ that attempts to identify backorders on jobs. When I
filter
> > to see if the job required qty is greater than stock qty, it works
fine
> > unless there is no PartBin record, in which case it returns null.
> >
> > I want the BAQ to work as follows:
> >
> > If PartBin.OnhandQty = Null Then 0 Else PartBin.OnhandQty
> >
> > How do I write this in a calculated field in BAQ?
> >
> > Thanks in advance,
> >
> > Randy Weber
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
>
[Non-text portions of this message have been removed]