BPM using variables [Vantage 8x]

Yahoo Archive
1
Good catch! I didn't even see that when I was looking at the code! You're
definitely right on that one.

On Wed, Jun 6, 2012 at 4:56 PM, Kirstin Brandt
<kirstin.brandt@...>wrote:

> **
>
>
> Did you try it without the quotes? It looks to me like you're comparing
> joboper.SetUpCrewSize with the string "crewS" and not the value of the
> variable crewS.
>
>
> --- In vantage@yahoogroups.com, "daniellaidig" <daniellaidig@...> wrote:
> >
> > I am trying to use a query in BPM along with a variable. I pasted a
> sample of
> > some simplified code that i was trying to test below. I defined a
> variable crewS
> > and assigned it 10. then i run a query to find my joboper with a setup
> crew less
> > than this. I understand i could eliminate the variable setting in this
> example,
> > but i am trying to figure out how it works.
> >
> > This code compiles but it never returns any rows.
> >
> >
> > for each ttLaborDtl , each joboper where ttLaborDtl.JobNum =
> joboper.JobNum and
> > ttLaborDtl.OprSeq = joboper.OprSeq:
> > define variable crewS as Integer no-undo
> > ASSIGN crewS = 10
> > END
> >
> > for each ttLaborDtl , each joboper where ttLaborDtl.JobNum =
> joboper.JobNum and
> > joboper.SetUpCrewSize < 'crewS'
> >
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
2
I am trying to use a query in BPM along with a variable. I pasted a sample of
some simplified code that i was trying to test below. I defined a variable crewS
and assigned it 10. then i run a query to find my joboper with a setup crew less
than this. I understand i could eliminate the variable setting in this example,
but i am trying to figure out how it works.

This code compiles but it never returns any rows.


for each ttLaborDtl , each joboper where ttLaborDtl.JobNum = joboper.JobNum and
ttLaborDtl.OprSeq = joboper.OprSeq:
define variable crewS as Integer no-undo
ASSIGN crewS = 10
END

for each ttLaborDtl , each joboper where ttLaborDtl.JobNum = joboper.JobNum and
joboper.SetUpCrewSize < 'crewS'
3
Did you try it without the quotes? It looks to me like you're comparing joboper.SetUpCrewSize with the string "crewS" and not the value of the variable crewS.

--- In vantage@yahoogroups.com, "daniellaidig" <daniellaidig@...> wrote:
>
> I am trying to use a query in BPM along with a variable. I pasted a sample of
> some simplified code that i was trying to test below. I defined a variable crewS
> and assigned it 10. then i run a query to find my joboper with a setup crew less
> than this. I understand i could eliminate the variable setting in this example,
> but i am trying to figure out how it works.
>
> This code compiles but it never returns any rows.
>
>
> for each ttLaborDtl , each joboper where ttLaborDtl.JobNum = joboper.JobNum and
> ttLaborDtl.OprSeq = joboper.OprSeq:
> define variable crewS as Integer no-undo
> ASSIGN crewS = 10
> END
>
> for each ttLaborDtl , each joboper where ttLaborDtl.JobNum = joboper.JobNum and
> joboper.SetUpCrewSize < 'crewS'
>