Simple? BAQ Question V8.03.405a

Yahoo Archive
1
Never Fails - ask a question and find the problem immediately after.....

Had to alter the table relations:

for each POHeader where ( POHeader.OpenOrder = yes AND POHeader.CheckBox01 = no) no-lock , each PODetail where ( PODetail.OpenLine = yes) and (POHeader.Company = PODetail.Company and POHeader.PONum = PODetail.PONUM) no-lock , each PORel where ( PORel.OpenRelease = yes) and (PODetail.Company = PORel.Company and PODetail.PONUM = PORel.PONum and PODetail.POLine = PORel.POLine) no-lock .

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I am trying to retrieve the number (count) of PO Releases per PO Line.
>
> The Phrase Builder has this:
>
> for each POHeader where ( POHeader.OpenOrder = yes AND POHeader.CheckBox01 = no) no-lock , each PODetail where ( PODetail.OpenLine = yes) and (POHeader.Company = PODetail.Company and POHeader.PONum = PODetail.PONUM) no-lock , each PORel where ( PORel.OpenRelease = yes) and (POHeader.Company = PORel.Company and POHeader.PONum = PORel.PONum) no-lock .
>
> What sort of a Calc field can I use to count the number of releases per line?
>
> I have tried COUNT(PORel.PORelNum) and it returns the total releases on all the POLines
>
> Is what I want possible?
>
> bw
>
2
I am trying to retrieve the number (count) of PO Releases per PO Line.

The Phrase Builder has this:

for each POHeader where ( POHeader.OpenOrder = yes AND POHeader.CheckBox01 = no) no-lock , each PODetail where ( PODetail.OpenLine = yes) and (POHeader.Company = PODetail.Company and POHeader.PONum = PODetail.PONUM) no-lock , each PORel where ( PORel.OpenRelease = yes) and (POHeader.Company = PORel.Company and POHeader.PONum = PORel.PONum) no-lock .

What sort of a Calc field can I use to count the number of releases per line?

I have tried COUNT(PORel.PORelNum) and it returns the total releases on all the POLines

Is what I want possible?

bw