Vantage 6.1 Dashboard Programming - How to find if XPartNum fiel

Index(OrderDtl.LineDesc,OrderDtl.XPartNum) >= 1

----- Original Message -----
From: "Winter, Patrick" <pjw@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, October 11, 2007 2:30 PM
Subject: [Vantage] Vantage 6.1 Dashboard Programming - How to find if XPartNum field in the string of LineDesc


All,



I'm trapping sales order entry issues with a dashboard. (Vantage 6.1)

I'm in the OrderDtl table trying to see if the XPartNum field is in the
field LineDesc.

We would have a LineDesc of "Acme Part XX22" and XPartNum of "XX22", so
I want to check for XX22 in the LineDesc.



What progress syntax could be used?



Patrick



My Query Statement



for each OrderDtl Where OrderDtl.Company = cur-comp

and OrderDtl.OpenLine = yes

and OrderDtl.CheckBox01 = no no-lock,

Each OrderHed Where OrderHed.Company = OrderDtl.Company

and OrderHed.OrderNum = OrderDtl.OrderNum

and OrderHed.OpenOrder = yes no-lock,

Each Customer Where OrderHed.Company = Customer.Company

and Customer.CustNum = OrderHed.CustNum

and ((OrderDtl.PricePerCode <> 'E')

or (OrderDtl.UnitPrice <= 0

and OrderHed.PONum <> 'Planning'

and OrderDtl.OrderQty > 30)

or (Length(OrderHed.PONum) = 0)

or (OrderDtl.Commissionable = False)

or (OrderDtl.TMBilling = True)

or (OrderDtl.OverRidePriceLi = True)

or (Length(OrderHed.ShipVia) = 0)

or (Length(OrderHed.FOB) = 0)

or (OrderDtl.OrderQty = 0)

or (OrderDtl.Rework = Yes)

or (Length(OrderDtl.XPartNum) = 0)

) no-lock

BY Customer.Character08

By OrderDtl.OrderNum Descending

By OrderDtl.OrderLine:



This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links




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



I'm trapping sales order entry issues with a dashboard. (Vantage 6.1)

I'm in the OrderDtl table trying to see if the XPartNum field is in the
field LineDesc.

We would have a LineDesc of "Acme Part XX22" and XPartNum of "XX22", so
I want to check for XX22 in the LineDesc.



What progress syntax could be used?



Patrick



My Query Statement



for each OrderDtl Where OrderDtl.Company = cur-comp

and OrderDtl.OpenLine = yes

and OrderDtl.CheckBox01 = no no-lock,

Each OrderHed Where OrderHed.Company = OrderDtl.Company

and OrderHed.OrderNum = OrderDtl.OrderNum

and OrderHed.OpenOrder = yes no-lock,

Each Customer Where OrderHed.Company = Customer.Company

and Customer.CustNum = OrderHed.CustNum

and ((OrderDtl.PricePerCode <> 'E')

or (OrderDtl.UnitPrice <= 0

and OrderHed.PONum <> 'Planning'

and OrderDtl.OrderQty > 30)

or (Length(OrderHed.PONum) = 0)

or (OrderDtl.Commissionable = False)

or (OrderDtl.TMBilling = True)

or (OrderDtl.OverRidePriceLi = True)

or (Length(OrderHed.ShipVia) = 0)

or (Length(OrderHed.FOB) = 0)

or (OrderDtl.OrderQty = 0)

or (OrderDtl.Rework = Yes)

or (Length(OrderDtl.XPartNum) = 0)

) no-lock

BY Customer.Character08

By OrderDtl.OrderNum Descending

By OrderDtl.OrderLine:



This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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