OrderHed.SalesRepList in 9.05.700

Yahoo Archive
1
Thanks on this!  Even though your post is from almost a year ago, it's fixed my BAQ problem!   Laraine   --- In vantage@yahoogroups.com, <vantage@...> wrote: Use 4 four ~~~~. Ie. IF (Num-entries(OrderHed.SalesRepList , "~~~~")>=1)
then



From: vantage@yahoogroups.com [mailto: vantage@yahoogroups.com ] On Behalf Of
b_ordway
Sent: Friday, September 07, 2012 3:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OrderHed.SalesRepList in 9.05.700





Anybody running into problems in 9.05.7 with calculated fields using
Num-entries and Entry to separate the OrderHed.SalesRepList?

I've used this in previous versions but no luck so far in 9.05.700:

SalesRep1:
IF (Num-entries(OrderHed.SalesRepList , "~~")>=1) then
Entry(1, OrderHed.SalesRepList , "~~") else ""

SalesRep2:
IF (Num-entries(OrderHed.SalesRepList , "~~")>=2) then
Entry(2, OrderHed.SalesRepList , "~~") else ""

The syntax passes in the BAQ designer - but I get this error when I test:
"Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
Please contact your System Administrator."

Thanks





[Non-text portions of this message have been removed]
2
Anybody running into problems in 9.05.7 with calculated fields using Num-entries and Entry to separate the OrderHed.SalesRepList?

I've used this in previous versions but no luck so far in 9.05.700:

SalesRep1:
IF (Num-entries(OrderHed.SalesRepList , "~~")>=1) then
Entry(1, OrderHed.SalesRepList , "~~") else ""

SalesRep2:
IF (Num-entries(OrderHed.SalesRepList , "~~")>=2) then
Entry(2, OrderHed.SalesRepList , "~~") else ""

The syntax passes in the BAQ designer - but I get this error when I test: "Table: , Level:, Type: , RowID: , Text: Business Query Execution error. Please contact your System Administrator."

Thanks
3
Use 4 four ~~~~. Ie. IF (Num-entries(OrderHed.SalesRepList , "~~~~")>=1)
then



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
b_ordway
Sent: Friday, September 07, 2012 3:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OrderHed.SalesRepList in 9.05.700





Anybody running into problems in 9.05.7 with calculated fields using
Num-entries and Entry to separate the OrderHed.SalesRepList?

I've used this in previous versions but no luck so far in 9.05.700:

SalesRep1:
IF (Num-entries(OrderHed.SalesRepList , "~~")>=1) then
Entry(1, OrderHed.SalesRepList , "~~") else ""

SalesRep2:
IF (Num-entries(OrderHed.SalesRepList , "~~")>=2) then
Entry(2, OrderHed.SalesRepList , "~~") else ""

The syntax passes in the BAQ designer - but I get this error when I test:
"Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
Please contact your System Administrator."

Thanks





[Non-text portions of this message have been removed]
4
Thanks, this worked in the query I needed it to.

Seems strange, I guess I'll have to take a fresh look.

I had just tested it again in a simpler query - still using "~~"
In the simpler query "~~" worked?

--- In vantage@yahoogroups.com, "Steve_E" <vantage@...> wrote:
>
> Use 4 four ~~~~. Ie. IF (Num-entries(OrderHed.SalesRepList , "~~~~")>=1)
> then
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> b_ordway
> Sent: Friday, September 07, 2012 3:23 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] OrderHed.SalesRepList in 9.05.700
>
>
>
>
>
> Anybody running into problems in 9.05.7 with calculated fields using
> Num-entries and Entry to separate the OrderHed.SalesRepList?
>
> I've used this in previous versions but no luck so far in 9.05.700:
>
> SalesRep1:
> IF (Num-entries(OrderHed.SalesRepList , "~~")>=1) then
> Entry(1, OrderHed.SalesRepList , "~~") else ""
>
> SalesRep2:
> IF (Num-entries(OrderHed.SalesRepList , "~~")>=2) then
> Entry(2, OrderHed.SalesRepList , "~~") else ""
>
> The syntax passes in the BAQ designer - but I get this error when I test:
> "Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
> Please contact your System Administrator."
>
> Thanks
>
>
>
>
>
> [Non-text portions of this message have been removed]
>