NOT BEGIN Blank Title 96601

Yahoo Archive
1
You do not have to go to E9. That checkbox occured in 8.03.409.
Bob Carlson
bcarlson@...

At 10:42 AM 1/7/2011, you wrote:
>
>
>I will try it and use Carl's code. Thanks again.
>
>________________________________
>From:
><mailto:vantage%40yahoogroups.com>vantage@yahoogroups.com
>[mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
>Sent: Friday, January 07, 2011 9:31 AM
>To: <mailto:vantage%40yahoogroups.com>vantage@yahoogroups.com
>Subject: Re: [Vantage] NOT BEGIN
>
>On Fri, Jan 7, 2011 at 8:12 AM, Bill Wu
><<mailto:billw%40libertypumps.com>billw@...<mailto:billw%40libertypumps.com>>
>wrote:
>
> > Thank you Carl, the problem is BAQ designer
> does not allow me to make changes in the phrase builder area.
> > Mark, our version does not have that
> checkbox. Looks like we need to upgrade to 9.
>
>If you feel adventurous, you can export the BAQ to the XML file,
>modify the code to add the NOT, and try importing it into a different
>named BAQ and see if you can "out smart" the system.
>
>Mark W.
>
>[Non-text portions of this message have been removed]
>
>

Robert (Bob) Carlson
rcarlson@...
Mobile: 603-883-8093

[Non-text portions of this message have been removed]
2
I need to do a query with condition of (ProdCode Not BEGIN '1C') in BAQ. Epicor only has BEGIN, there is no "NOT BEGIN". I cannot figure out how. Can some one help? Our version is 407.


[Non-text portions of this message have been removed]
3
How about substring(prodgrup.prodcode,1,2) <> "1C" or
Lookup(prodgrup.prodcode,"1C,1E") = 0

You could any file name

Sent from my iPhone
1-734-812-9532 - cell#

On Jan 6, 2011, at 3:59 PM, Bill Wu <billw@...> wrote:

> I need to do a query with condition of (ProdCode Not BEGIN '1C') in BAQ. Epicor only has BEGIN, there is no "NOT BEGIN". I cannot figure out how. Can some one help? Our version is 407.
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]
4
Bill asks:
> I need to do a query with condition of (ProdCode Not BEGIN '1C') in BAQ. Epicor only has BEGIN, there is no "NOT BEGIN".
> I cannot figure out how. Can some one help? Our version is 407.

I don't recall the 8.03 BAQ Designer but in 9.04 there's a "Not"
checkbox to the left of the field and to the right of the Left-Paren
field. Is there something similar in V8?

Mark W.
5
Use the substring with the Lookup, too!

Lookup(substring(prodcode,1,2),"1C,1E") = 0

Sorry!

Sent from my iPhone
1-734-812-9532 - cell#

On Jan 6, 2011, at 3:59 PM, Bill Wu <billw@...> wrote:

> I need to do a query with condition of (ProdCode Not BEGIN '1C') in BAQ. Epicor only has BEGIN, there is no "NOT BEGIN". I cannot figure out how. Can some one help? Our version is 407.
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]
6
Thank you Carl, the problem is BAQ designer does not allow me to make changes in the phrase builder area. Mark, our version does not have that checkbox. Looks like we need to upgrade to 9.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Carl Peterson
Sent: Thursday, January 06, 2011 4:44 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] NOT BEGIN



Use the substring with the Lookup, too!

Lookup(substring(prodcode,1,2),"1C,1E") = 0

Sorry!

Sent from my iPhone
1-734-812-9532 - cell#

On Jan 6, 2011, at 3:59 PM, Bill Wu <billw@...<mailto:billw%40libertypumps.com>> wrote:

> I need to do a query with condition of (ProdCode Not BEGIN '1C') in BAQ. Epicor only has BEGIN, there is no "NOT BEGIN". I cannot figure out how. Can some one help? Our version is 407.
>
> [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]
7
On Fri, Jan 7, 2011 at 8:12 AM, Bill Wu <billw@...> wrote:

> Thank you Carl, the problem is BAQ designer does not allow me to make changes in the phrase builder area.
> Mark, our version does not have that checkbox. Looks like we need to upgrade to 9.

If you feel adventurous, you can export the BAQ to the XML file,
modify the code to add the NOT, and try importing it into a different
named BAQ and see if you can "out smart" the system.

Mark W.
8
I will try it and use Carl's code. Thanks again.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Friday, January 07, 2011 9:31 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] NOT BEGIN



On Fri, Jan 7, 2011 at 8:12 AM, Bill Wu <billw@...<mailto:billw%40libertypumps.com>> wrote:

> Thank you Carl, the problem is BAQ designer does not allow me to make changes in the phrase builder area.
> Mark, our version does not have that checkbox. Looks like we need to upgrade to 9.

If you feel adventurous, you can export the BAQ to the XML file,
modify the code to add the NOT, and try importing it into a different
named BAQ and see if you can "out smart" the system.

Mark W.



[Non-text portions of this message have been removed]