BPM to delete a line

Yahoo Archive
1
You might be eligible for a new Progress 4GL Development Code that would then allow update.
You'll need to ask your CAM and probably reference Answerbook 10428MPS.

I needed this installed before an update BPM would work.



--- In vantage@yahoogroups.com, "sanjay219@..." <sanjay219@...> wrote:
>
> I cant compile this code, as i am using 8.03.409c, which cant update the database. ("delete shipmisc" cant be done)
>
2
Is it possible to delete a line via BPM? I am looking for a way to delete a Misc Charges line in Customer Shipment Entry based on certain conditions.
3
Find first tablename where
Criteria exclusive-lock no-error.

If avail tablename then do:

Delete tablename.

End.


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanjay219@...
Sent: Wednesday, May 29, 2013 7:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM to delete a line



Is it possible to delete a line via BPM? I am looking for a way to delete a Misc Charges line in Customer Shipment Entry based on certain conditions.



[Non-text portions of this message have been removed]
4
Thanks for the reply. I tried the following code:

find first ttshipmisc where ttshipmisc.MiscAmt>5000 no-lock no-error.
if available ttshipmisc then do:
delete ttshipmisc.
end.

But the line is not getting deleted.
5
Try...

Find first shipmisc where
Shipmisc.miscamt > 500 exclusive-lock no-error.

If avail shipmisc then do:

Delete shipmisc.

End.


Basically the same as what you have... without the tt in front on the table name.


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanjay219@...
Sent: Wednesday, May 29, 2013 8:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM to delete a line



Thanks for the reply. I tried the following code:

find first ttshipmisc where ttshipmisc.MiscAmt>5000 no-lock no-error.
if available ttshipmisc then do:
delete ttshipmisc.
end.

But the line is not getting deleted.



[Non-text portions of this message have been removed]
6
I cant compile this code, as i am using 8.03.409c, which cant update the database. ("delete shipmisc" cant be done)
7
Where are you running this from? What method or data directive?


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanjay219@...
Sent: Wednesday, May 29, 2013 9:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM to delete a line



I cant compile this code, as i am using 8.03.409c, which cant update the database. ("delete shipmisc" cant be done)



[Non-text portions of this message have been removed]
8
There is no data directive in my version(V8.03). Running in CustShip.Update pre-processing method directive.
9
Have you checked with Insite on this miscellaneous charge being added?



If you use the correct billing type under Manifest Info - it should not add
a miscellaneous charge.



It is the Insite interface adding this charge.



There is also one other area and that is how the miscellaneous charge is
setup. In company configurations under Modules > Materials > Shipping
Receiving - there is a default misc Freight code.



When we use the Billing Type of shipper and the default misc Freight code,
we do not get a miscellaneous charge added to the packslip.



We set this up so long ago, I would recommend calling Insite to go over the
setup.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sanjay219@...
Sent: Wednesday, May 29, 2013 9:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM to delete a line





There is no data directive in my version(V8.03). Running in CustShip.Update
pre-processing method directive.





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