Problem with pre-processing directive

Yahoo Archive
1
I tried:



Condition: Number of rows in the 'qryCkSalesperson' query is not less
than 1

Query: for each ttOrderhed where tt OrderHed.SalesRepList = ""

Action: raise exception based on the tempSlsTest3 template



I still have the same problem. The directive fires, but does not go
away after I select a salesperson.



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Problem with pre-processing directive





Then your other option is to see if a query returns > 0 rows and create
your
own query

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 11:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive

Thanks, I noticed that too. I pick the ttOrderHed table from the list
and click on the SalesRepList checkbox then hit Ok and it shows me
OrderHed instead of ttOrderHed in the condition.

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive

It looks like you are querying the OrderHed table instead of the
TTOrderHed
table.

The ordered would be live data, the TTORderHed is data that is at the
form
level and may or may not be at the "live" level.

If you are pre-processing then ttOrderHed contains changes made at the
form
and OrderHed would contain the original values.

If you are post-processing then ttOrderHed and OrderHed should be
identical
I would think.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 9:59 AM
To: Vantage@yahoogroups.com <mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
Subject: [Vantage] Problem with pre-processing directive

I'm having a problem with this method directive that is supposed to
check for a missing salesperson on an order:

Business Object: SalesOrder.Update

Conditions: the OrderHed.SalesRepList field of the changed row is equal
to the "" value

Action: raise exception based on the tmpSalesperson template

This works great and sends an error message, but when the user selects a
salesperson from the list and then presses the save button the message
pops up again. Can anyone tell me what I've done wrong?

Regards,

Linda Lowney

Software Specialist

Pride Signs

255 Pinebush Road

Cambridge, ON N1T 1B9

P 519 622 4040 ext. 258

F 519 622 4031

www.pridesigns.com <http://www.pridesigns.com>

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

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





[Non-text portions of this message have been removed]
2
I'm having a problem with this method directive that is supposed to
check for a missing salesperson on an order:



Business Object: SalesOrder.Update

Conditions: the OrderHed.SalesRepList field of the changed row is equal
to the "" value

Action: raise exception based on the tmpSalesperson template





This works great and sends an error message, but when the user selects a
salesperson from the list and then presses the save button the message
pops up again. Can anyone tell me what I've done wrong?



Regards,



Linda Lowney

Software Specialist



Pride Signs

255 Pinebush Road

Cambridge, ON N1T 1B9



P 519 622 4040 ext. 258

F 519 622 4031



www.pridesigns.com <http://www.pridesigns.com>









[Non-text portions of this message have been removed]
3
It looks like you are querying the OrderHed table instead of the TTOrderHed
table.

The ordered would be live data, the TTORderHed is data that is at the form
level and may or may not be at the "live" level.

If you are pre-processing then ttOrderHed contains changes made at the form
and OrderHed would contain the original values.

If you are post-processing then ttOrderHed and OrderHed should be identical
I would think.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 9:59 AM
To: Vantage@yahoogroups.com
Subject: [Vantage] Problem with pre-processing directive





I'm having a problem with this method directive that is supposed to
check for a missing salesperson on an order:

Business Object: SalesOrder.Update

Conditions: the OrderHed.SalesRepList field of the changed row is equal
to the "" value

Action: raise exception based on the tmpSalesperson template

This works great and sends an error message, but when the user selects a
salesperson from the list and then presses the save button the message
pops up again. Can anyone tell me what I've done wrong?

Regards,

Linda Lowney

Software Specialist

Pride Signs

255 Pinebush Road

Cambridge, ON N1T 1B9

P 519 622 4040 ext. 258

F 519 622 4031

www.pridesigns.com <http://www.pridesigns.com>

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





[Non-text portions of this message have been removed]
4
Thanks, I noticed that too. I pick the ttOrderHed table from the list
and click on the SalesRepList checkbox then hit Ok and it shows me
OrderHed instead of ttOrderHed in the condition.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Problem with pre-processing directive





It looks like you are querying the OrderHed table instead of the
TTOrderHed
table.

The ordered would be live data, the TTORderHed is data that is at the
form
level and may or may not be at the "live" level.

If you are pre-processing then ttOrderHed contains changes made at the
form
and OrderHed would contain the original values.

If you are post-processing then ttOrderHed and OrderHed should be
identical
I would think.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 9:59 AM
To: Vantage@yahoogroups.com <mailto:Vantage%40yahoogroups.com>
Subject: [Vantage] Problem with pre-processing directive

I'm having a problem with this method directive that is supposed to
check for a missing salesperson on an order:

Business Object: SalesOrder.Update

Conditions: the OrderHed.SalesRepList field of the changed row is equal
to the "" value

Action: raise exception based on the tmpSalesperson template

This works great and sends an error message, but when the user selects a
salesperson from the list and then presses the save button the message
pops up again. Can anyone tell me what I've done wrong?

Regards,

Linda Lowney

Software Specialist

Pride Signs

255 Pinebush Road

Cambridge, ON N1T 1B9

P 519 622 4040 ext. 258

F 519 622 4031

www.pridesigns.com <http://www.pridesigns.com>

[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]
5
Then your other option is to see if a query returns > 0 rows and create your
own query



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Problem with pre-processing directive





Thanks, I noticed that too. I pick the ttOrderHed table from the list
and click on the SalesRepList checkbox then hit Ok and it shows me
OrderHed instead of ttOrderHed in the condition.

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sean McDaniel
Sent: Tuesday, November 03, 2009 11:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Problem with pre-processing directive

It looks like you are querying the OrderHed table instead of the
TTOrderHed
table.

The ordered would be live data, the TTORderHed is data that is at the
form
level and may or may not be at the "live" level.

If you are pre-processing then ttOrderHed contains changes made at the
form
and OrderHed would contain the original values.

If you are post-processing then ttOrderHed and OrderHed should be
identical
I would think.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Linda Lowney
Sent: Tuesday, November 03, 2009 9:59 AM
To: Vantage@yahoogroups.com <mailto:Vantage%40yahoogroups.com>
<mailto:Vantage%40yahoogroups.com>
Subject: [Vantage] Problem with pre-processing directive

I'm having a problem with this method directive that is supposed to
check for a missing salesperson on an order:

Business Object: SalesOrder.Update

Conditions: the OrderHed.SalesRepList field of the changed row is equal
to the "" value

Action: raise exception based on the tmpSalesperson template

This works great and sends an error message, but when the user selects a
salesperson from the list and then presses the save button the message
pops up again. Can anyone tell me what I've done wrong?

Regards,

Linda Lowney

Software Specialist

Pride Signs

255 Pinebush Road

Cambridge, ON N1T 1B9

P 519 622 4040 ext. 258

F 519 622 4031

www.pridesigns.com <http://www.pridesigns.com>

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





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