E9 Product Configurator: Updating another table from ONLEAVE

Yahoo Archive
1
The Progress license that originaly came with Vantage only allowed you to write to temp tables from custom code, all the other tables you could only write code that reads them. You could purchase a full developers license that would allow you to do everything, but that is expensive. Epicor created a .p program called updatetablebuffer that would allow you to change a field in a table, but it was awkward to use and did not allow you to add a new record.Â

Recently, Epicor negotied a new Progress license agreement from OpenEdge that would allow you (from the Vantage enviroment) to write code that added, deleted, and/or update any Vantage table. It is free for anyone currently on maintenance with Epicor.




________________________________
From: Joe Rojas <jrojas@...>
To: vantage@yahoogroups.com
Sent: Mon, April 26, 2010 1:19:52 PM
Subject: RE: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE

Â
Thanks Steven,

If you don’t mind, could you expand I little on the licensing?

What is the “new OpenEdge license”? Is this something we get for free?

Any ideas what the going price is for a full OpenEdge license?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Steven Gotschall
Sent: Monday, April 26, 2010 1:01 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE

Two things come to mind off the top of my head.

If any of these are system variables (like Company), first assign them to your own variable and then use your own variable in the where clause. I have found that trying to use system variables directly in a where clause or comparison operation can be iffy.

If you don't have the new OpenEdge license from Epicor, or you havn't purchased a full Progress license from OpenEdge, then you can not directly assign values to anything other then Temp Tables. Use the UpdateTableBuffer statement instead, or ask you rep for the new OpenEdge license. Another way you could do this is to assign it by using a rule at the ALT level of the Rules Page.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

____________ _________ _________ __

From: Joe Rojas <jrojas@matsinc. com <mailto:jrojas% 40matsinc. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Mon, April 26, 2010 11:31:47 AM
Subject: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE

Hi All,

I'm trying to update the values in QuoteQty from the On Leave of a page.

First, should I be able to do this? We are trying to streamline our
process and we would rather not have someone type in the quantity are
price into the Quantities section because the configurator already
calculates this for us.

If I should be able to do this, do you see anything wrong with my code?

Find First QuoteQty where QuoteQty.Company = Company

and QuoteQty.QuoteNum =
INTEGER(CurQuoteNum )

AND QuoteQty.QuoteLine =
INTEGER(FILLIN1)

no-lock no-error.

If available QuoteQty Then DO:

ASSIGN QuoteQty.SellingQua ntity = entqty.

ASSIGN QuoteQty.DocUnitPri ce = eaprice.

End.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[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
Hi All,



I'm trying to update the values in QuoteQty from the On Leave of a page.

First, should I be able to do this? We are trying to streamline our
process and we would rather not have someone type in the quantity are
price into the Quantities section because the configurator already
calculates this for us.



If I should be able to do this, do you see anything wrong with my code?



Find First QuoteQty where QuoteQty.Company = Company

and QuoteQty.QuoteNum =
INTEGER(CurQuoteNum)

AND QuoteQty.QuoteLine =
INTEGER(FILLIN1)

no-lock no-error.



If available QuoteQty Then DO:

ASSIGN QuoteQty.SellingQuantity = entqty.

ASSIGN QuoteQty.DocUnitPrice = eaprice.

End.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
Two things come to mind off the top of my head.

If any of these are system variables (like Company), first assign them to your own variable and then use your own variable in the where clause. I have found that trying to use system variables directly in a where clause or comparison operation can be iffy.

If you don't have the new OpenEdge license from Epicor, or you havn't purchased a full Progress license from OpenEdge, then you can not directly assign values to anything other then Temp Tables. Use the UpdateTableBuffer statement instead, or ask you rep for the new OpenEdge license. Another way you could do this is to assign it by using a rule at the ALT level of the Rules Page.




________________________________
From: Joe Rojas <jrojas@...>
To: vantage@yahoogroups.com
Sent: Mon, April 26, 2010 11:31:47 AM
Subject: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE

Â
Hi All,

I'm trying to update the values in QuoteQty from the On Leave of a page.

First, should I be able to do this? We are trying to streamline our
process and we would rather not have someone type in the quantity are
price into the Quantities section because the configurator already
calculates this for us.

If I should be able to do this, do you see anything wrong with my code?

Find First QuoteQty where QuoteQty.Company = Company

and QuoteQty.QuoteNum =
INTEGER(CurQuoteNum )

AND QuoteQty.QuoteLine =
INTEGER(FILLIN1)

no-lock no-error.

If available QuoteQty Then DO:

ASSIGN QuoteQty.SellingQua ntity = entqty.

ASSIGN QuoteQty.DocUnitPri ce = eaprice.

End.







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

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







[Non-text portions of this message have been removed]
4
Thanks Steven,



If you don’t mind, could you expand I little on the licensing?

What is the “new OpenEdge license”? Is this something we get for free?

Any ideas what the going price is for a full OpenEdge license?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Monday, April 26, 2010 1:01 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE





Two things come to mind off the top of my head.

If any of these are system variables (like Company), first assign them to your own variable and then use your own variable in the where clause. I have found that trying to use system variables directly in a where clause or comparison operation can be iffy.

If you don't have the new OpenEdge license from Epicor, or you havn't purchased a full Progress license from OpenEdge, then you can not directly assign values to anything other then Temp Tables. Use the UpdateTableBuffer statement instead, or ask you rep for the new OpenEdge license. Another way you could do this is to assign it by using a rule at the ALT level of the Rules Page.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



________________________________

From: Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, April 26, 2010 11:31:47 AM
Subject: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE


Hi All,

I'm trying to update the values in QuoteQty from the On Leave of a page.

First, should I be able to do this? We are trying to streamline our
process and we would rather not have someone type in the quantity are
price into the Quantities section because the configurator already
calculates this for us.

If I should be able to do this, do you see anything wrong with my code?

Find First QuoteQty where QuoteQty.Company = Company

and QuoteQty.QuoteNum =
INTEGER(CurQuoteNum )

AND QuoteQty.QuoteLine =
INTEGER(FILLIN1)

no-lock no-error.

If available QuoteQty Then DO:

ASSIGN QuoteQty.SellingQua ntity = entqty.

ASSIGN QuoteQty.DocUnitPri ce = eaprice.

End.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[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
BTW. I’m planning on looking at the UpdateTableBuffer method (thanks for the lead). I don’t see how to update the table QuoteQty from the ALT method rules. None of its fields are available. Just QuoteHed and QuoteDtl.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Monday, April 26, 2010 1:01 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE





Two things come to mind off the top of my head.

If any of these are system variables (like Company), first assign them to your own variable and then use your own variable in the where clause. I have found that trying to use system variables directly in a where clause or comparison operation can be iffy.

If you don't have the new OpenEdge license from Epicor, or you havn't purchased a full Progress license from OpenEdge, then you can not directly assign values to anything other then Temp Tables. Use the UpdateTableBuffer statement instead, or ask you rep for the new OpenEdge license. Another way you could do this is to assign it by using a rule at the ALT level of the Rules Page.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



________________________________

From: Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, April 26, 2010 11:31:47 AM
Subject: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE


Hi All,

I'm trying to update the values in QuoteQty from the On Leave of a page.

First, should I be able to do this? We are trying to streamline our
process and we would rather not have someone type in the quantity are
price into the Quantities section because the configurator already
calculates this for us.

If I should be able to do this, do you see anything wrong with my code?

Find First QuoteQty where QuoteQty.Company = Company

and QuoteQty.QuoteNum =
INTEGER(CurQuoteNum )

AND QuoteQty.QuoteLine =
INTEGER(FILLIN1)

no-lock no-error.

If available QuoteQty Then DO:

ASSIGN QuoteQty.SellingQua ntity = entqty.

ASSIGN QuoteQty.DocUnitPri ce = eaprice.

End.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[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]
6
The Progress license that originally came with Vantage only allowed you to write to temp tables from custom 4GL code, all the other tables you could only create code that reads them. You could purchase a full developers license that would allow you to do everything, but that is expensive. Epicor created a .p program called updatetablebuffer that would allow you to change a field in a table, but it was awkward to use and did not allow you to add a new record.Â

Recently, Epicor negotiated a new Progress license agreement from OpenEdge that would allow you (from the Vantage environment) to write code that added, deleted, and/or update any Vantage table. It is free for anyone currently on maintenance with Epicor.




________________________________
From: Joe Rojas <jrojas@...>
To: vantage@yahoogroups.com
Sent: Mon, April 26, 2010 1:19:52 PM
Subject: RE: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE

Â
Thanks Steven,

If you don’t mind, could you expand I little on the licensing?

What is the “new OpenEdge license”? Is this something we get for free?

Any ideas what the going price is for a full OpenEdge license?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Steven Gotschall
Sent: Monday, April 26, 2010 1:01 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE

Two things come to mind off the top of my head.

If any of these are system variables (like Company), first assign them to your own variable and then use your own variable in the where clause. I have found that trying to use system variables directly in a where clause or comparison operation can be iffy.

If you don't have the new OpenEdge license from Epicor, or you havn't purchased a full Progress license from OpenEdge, then you can not directly assign values to anything other then Temp Tables. Use the UpdateTableBuffer statement instead, or ask you rep for the new OpenEdge license. Another way you could do this is to assign it by using a rule at the ALT level of the Rules Page.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

____________ _________ _________ __

From: Joe Rojas <jrojas@matsinc. com <mailto:jrojas% 40matsinc. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Mon, April 26, 2010 11:31:47 AM
Subject: [Vantage] E9 Product Configurator: Updating another table from ONLEAVE

Hi All,

I'm trying to update the values in QuoteQty from the On Leave of a page.

First, should I be able to do this? We are trying to streamline our
process and we would rather not have someone type in the quantity are
price into the Quantities section because the configurator already
calculates this for us.

If I should be able to do this, do you see anything wrong with my code?

Find First QuoteQty where QuoteQty.Company = Company

and QuoteQty.QuoteNum =
INTEGER(CurQuoteNum )

AND QuoteQty.QuoteLine =
INTEGER(FILLIN1)

no-lock no-error.

If available QuoteQty Then DO:

ASSIGN QuoteQty.SellingQua ntity = entqty.

ASSIGN QuoteQty.DocUnitPri ce = eaprice.

End.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

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