Why does this BAQ not produce records?

Yahoo Archive
1
Your field joins between tables is incorrect then.

--- On Mon, 8/4/08, Tony Hughes <thughes281@...> wrote:

From: Tony Hughes <thughes281@...>
Subject: Re: [Vantage] why does this BAQ not produce records?
To: vantage@yahoogroups.com
Date: Monday, August 4, 2008, 2:11 PM






I tried yes/no, that is accepted when you "Analyze"
I also did integer, 0/1 but this is not accepted by BAQ when you "Analyze", datatype mismatch error

Strangely, I actually reduced the query to just: for each TFOrdDtl no-lock .
and still no results...

----- Original Message ----
From: Bill Jackson <fujijapman@yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, August 4, 2008 1:02:20 PM
Subject: Re: [Vantage] why does this BAQ not produce records?

Try using 'yes/no' or '1/0' for your boolena test( .Shipped)

--- On Mon, 8/4/08, Tony Hughes <thughes281@ yahoo. com> wrote:

From: Tony Hughes <thughes281@ yahoo. com>
Subject: [Vantage] why does this BAQ not produce records?
To: vantage@yahoogroups .com
Date: Monday, August 4, 2008, 1:57 PM

I made a BAQ with this:

for each TFOrdDtl where ( TFOrdDtl.Shipped = TRUE AND TFOrdDtl.ReceivedQt y < TFOrdDtl.OurStockSh ippedQty) no-lock by TFOrdDtl.TFOrdNum.

Analyze says "syntax OK", but a test produces no results.

If I run the same thing on my SQL server, I get hundreds of results (select * from tforddtl where Shipped = 1 AND (TFOrdDtl.ReceivedQ ty < TFOrdDtl.OurStockSh ippedQty) )

is there something wrong with my BAQ query?

Thank you,

Anthony Hughes
ERP Manager
Logan Oil Tools, Inc.
Houston, Texas

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

[Non-text portions of this message have been removed]
2
I made a BAQ with this:

for each TFOrdDtl where ( TFOrdDtl.Shipped = TRUE AND TFOrdDtl.ReceivedQty < TFOrdDtl.OurStockShippedQty) no-lock by TFOrdDtl.TFOrdNum.


Analyze says "syntax OK", but a test produces no results.

If I run the same thing on my SQL server, I get hundreds of results (select * from tforddtl where Shipped = 1 AND (TFOrdDtl.ReceivedQty < TFOrdDtl.OurStockShippedQty) )


is there something wrong with my BAQ query?

Thank you,





Anthony Hughes
ERP Manager
Logan Oil Tools, Inc.
Houston, Texas
3
 Try using 'yes/no' or '1/0' for your boolena test( .Shipped)

--- On Mon, 8/4/08, Tony Hughes <thughes281@...> wrote:

From: Tony Hughes <thughes281@...>
Subject: [Vantage] why does this BAQ not produce records?
To: vantage@yahoogroups.com
Date: Monday, August 4, 2008, 1:57 PM






I made a BAQ with this:

for each TFOrdDtl where ( TFOrdDtl.Shipped = TRUE AND TFOrdDtl.ReceivedQt y < TFOrdDtl.OurStockSh ippedQty) no-lock by TFOrdDtl.TFOrdNum.

Analyze says "syntax OK", but a test produces no results.

If I run the same thing on my SQL server, I get hundreds of results (select * from tforddtl where Shipped = 1 AND (TFOrdDtl.ReceivedQ ty < TFOrdDtl.OurStockSh ippedQty) )

is there something wrong with my BAQ query?

Thank you,

Anthony Hughes
ERP Manager
Logan Oil Tools, Inc.
Houston, Texas


















[Non-text portions of this message have been removed]
4
I tried yes/no, that is accepted when you "Analyze"
I also did integer, 0/1 but this is not accepted by BAQ when you "Analyze", datatype mismatch error

Strangely, I actually reduced the query to just: for each TFOrdDtl no-lock .
and still no results...





----- Original Message ----
From: Bill Jackson <fujijapman@...>
To: vantage@yahoogroups.com
Sent: Monday, August 4, 2008 1:02:20 PM
Subject: Re: [Vantage] why does this BAQ not produce records?


Try using 'yes/no' or '1/0' for your boolena test( .Shipped)

--- On Mon, 8/4/08, Tony Hughes <thughes281@yahoo. com> wrote:

From: Tony Hughes <thughes281@yahoo. com>
Subject: [Vantage] why does this BAQ not produce records?
To: vantage@yahoogroups .com
Date: Monday, August 4, 2008, 1:57 PM

I made a BAQ with this:

for each TFOrdDtl where ( TFOrdDtl.Shipped = TRUE AND TFOrdDtl.ReceivedQt y < TFOrdDtl.OurStockSh ippedQty) no-lock by TFOrdDtl.TFOrdNum.

Analyze says "syntax OK", but a test produces no results.

If I run the same thing on my SQL server, I get hundreds of results (select * from tforddtl where Shipped = 1 AND (TFOrdDtl.ReceivedQ ty < TFOrdDtl.OurStockSh ippedQty) )

is there something wrong with my BAQ query?

Thank you,

Anthony Hughes
ERP Manager
Logan Oil Tools, Inc.
Houston, Texas

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






[Non-text portions of this message have been removed]
5
I found it, it was my syntax error in the Calc field I made.
I did not put table name in front of the fields
I had a calc field with ourstockshippedqty - receivedqty but has to have table names (even when there's just the one table)
should be: tforddtl.ourstockshippedqty - tforddtl.receivedqty as intransit

Thanks for your help




----- Original Message ----
From: Tony Hughes <thughes281@...>
To: vantage@yahoogroups.com
Sent: Monday, August 4, 2008 1:11:51 PM
Subject: Re: [Vantage] why does this BAQ not produce records?


I tried yes/no, that is accepted when you "Analyze"
I also did integer, 0/1 but this is not accepted by BAQ when you "Analyze", datatype mismatch error

Strangely, I actually reduced the query to just: for each TFOrdDtl no-lock .
and still no results...

----- Original Message ----
From: Bill Jackson <fujijapman@yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, August 4, 2008 1:02:20 PM
Subject: Re: [Vantage] why does this BAQ not produce records?

Try using 'yes/no' or '1/0' for your boolena test( .Shipped)

--- On Mon, 8/4/08, Tony Hughes <thughes281@ yahoo. com> wrote:

From: Tony Hughes <thughes281@ yahoo. com>
Subject: [Vantage] why does this BAQ not produce records?
To: vantage@yahoogroups .com
Date: Monday, August 4, 2008, 1:57 PM

I made a BAQ with this:

for each TFOrdDtl where ( TFOrdDtl.Shipped = TRUE AND TFOrdDtl.ReceivedQt y < TFOrdDtl.OurStockSh ippedQty) no-lock by TFOrdDtl.TFOrdNum.

Analyze says "syntax OK", but a test produces no results.

If I run the same thing on my SQL server, I get hundreds of results (select * from tforddtl where Shipped = 1 AND (TFOrdDtl.ReceivedQ ty < TFOrdDtl.OurStockSh ippedQty) )

is there something wrong with my BAQ query?

Thank you,

Anthony Hughes
ERP Manager
Logan Oil Tools, Inc.
Houston, Texas

[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]