BMP Delete Row Blank Title 82761

We don't have the SDK, but I think all you have to do is install the Progress license that comes with it and you will be in buisness.




________________________________
From: mmcwilliams22 <mmcwilliams22@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 15, 2009 11:12:11 AM
Subject: [Vantage] Re: BMP Delete Row

Â
We do have the SDK. Have never used it since we have been able to do almost everything with script and BPMs. Guess it is time to learn. I know Epicor wants to charge a hefty fee for training, I wonder how far the manuals will get me?

--- In vantage@yahoogroups .com, Steven Gotschall <sgotschall@ ...> wrote:
>
> Unless you have a full Progress license or the SDK then you can not directly add, update, or delete records from code (well service connect can using the business objects, but I wouldn't call it a direct approach). With the Updatetablebuffer. p you can update a record, but I don't think it can add or delete a record. Here is some code I got a while back on deleteing data in a dataset. Its a VB customization so I don't know if it will meet your needs.
>
> This is for UD20, but just change to whatever table you need
> call the sub and pass it the dataset or incorporate into a button click
> or whatever - this is merely for concept :o)
>
> Private Sub deleteUD20Records( dsUD20 As DataSet)
> Dim adUD20 As UD20Adapter = New UD20Adapter( UD20Form)
> adUD20.BOConnect( )
> For Each dr As DataRow In dsUD20..Tables( 0).Rows
> Dim deleted As Boolean = adUD20.DeleteByID( dr("Key1" ),dr
> ("Key2"),dr( "Key3"),dr( "Key4"),dr( "Key5"))
> Next
> adUD20.Dispose( )
> End Sub
>
> Â
> MORE CODE:
> Private Sub cedEpiCustom1_ DoubleClick( ByVal Sender As Object, ByVal Args As System.EventArgs) Handles cedEpiCustom1. DoubleClick
> Â Â '// ** Place Event Handling Code Here **
> Â
> Â Â Dim edvOrderDtl As EpiDataView = CType(oTrans. EpiDataViews( "OrderDtl" ), EpiDataView)
> Â Â Â Â Dim I as Int32
> Â Â Â Â Dim TempRow as Int32
> Â Â If edvOrderDtl. Hasrow Then
> Â Â Â Â Â Â Â Â Â Â Â if 6 = msgbox("Would you like to update the Winco Price for all items on this Sales Order?",36," Update Winco Calculated Pricing")
> Â Â Â Â Â Â Â Â Â TempRow = edvOrderDtl. row
> Â Â Â Â Â Â Â Â Â Â Â Â for I = 0 to edvOrderDtl. DataView. Count - 1
> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â edvOrderDtl. Row = I
> Â Â Â Â Â Â Â Â Â Â edvOrderDtl. dataView( edvOrderDtl. Row)("SellingQua ntity") = edvOrderDtl. dataView( edvOrderDtl. Row)("SellingQua ntity")
> Â Â Â Â Â Â Â Â Â Â Â Â Next I
> Â Â Â Â Â Â Â Â edvOrderDtl. row = TempRow
> Â Â Â Â Â Â Â Â Â Â Â End If
> Â Â End If
> Â
> Â End Sub
>
>
>
> ____________ _________ _________ __
> From: mmcwilliams22 <mmcwilliams22@ ...>
> To: vantage@yahoogroups .com
> Sent: Tuesday, September 15, 2009 9:53:05 AM
> Subject: [Vantage] Re: BMP Delete Row
>
> Â
> I guess I must do it throught the updatetablebuffer somehow. I am getting this error using your method.
>
> The following application error was encountered:
>
> You may not compile programs that update the database in this version (490)
> ** Could not understand line 11. (196)
>
> --- In vantage@yahoogroups .com, Dimitris Kavvouras <d.kavvouras@ ....> wrote:
> >
> > Hi Williams ,
> >
> > Do you mean something like that? you don't need to specify any parameters, just fetch the record you wish to delete and delete it.
> > i.e. just as an example, delete all records from JobEntry where company is the CUR-COMP (Current selected company) and field "Somehting" equals no.
> >
> > FOR EACH ttJobEntry where ttJobEntry.Company = CUR-COMP:
> > if ttJobEntry.somethin g= false then
> > delete ttJobEntry.
> > end.
> >
> > ____________ _________ _________ __
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of mmcwilliams22
> > Sent: Tuesday, September 15, 2009 4:05 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] BMP Delete Row
> >
> >
> >
> > How can I delete a row using a BPM I know it is DELETE but I am not sure of parameters etc.
> >
> >
> >
> > [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]
How can I delete a row using a BPM I know it is DELETE but I am not sure of parameters etc.
Hi Williams ,

Do you mean something like that? you don't need to specify any parameters, just fetch the record you wish to delete and delete it.
i.e. just as an example, delete all records from JobEntry where company is the CUR-COMP (Current selected company) and field "Somehting" equals no.

FOR EACH ttJobEntry where ttJobEntry.Company = CUR-COMP:
if ttJobEntry.something= false then
delete ttJobEntry.
end.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mmcwilliams22
Sent: Tuesday, September 15, 2009 4:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BMP Delete Row



How can I delete a row using a BPM I know it is DELETE but I am not sure of parameters etc.



[Non-text portions of this message have been removed]
I guess I must do it throught the updatetablebuffer somehow. I am getting this error using your method.

The following application error was encountered:

You may not compile programs that update the database in this version (490)
** Could not understand line 11. (196)



--- In vantage@yahoogroups.com, Dimitris Kavvouras <d.kavvouras@...> wrote:
>
> Hi Williams ,
>
> Do you mean something like that? you don't need to specify any parameters, just fetch the record you wish to delete and delete it.
> i.e. just as an example, delete all records from JobEntry where company is the CUR-COMP (Current selected company) and field "Somehting" equals no.
>
> FOR EACH ttJobEntry where ttJobEntry.Company = CUR-COMP:
> if ttJobEntry.something= false then
> delete ttJobEntry.
> end.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mmcwilliams22
> Sent: Tuesday, September 15, 2009 4:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BMP Delete Row
>
>
>
> How can I delete a row using a BPM I know it is DELETE but I am not sure of parameters etc.
>
>
>
> [Non-text portions of this message have been removed]
>
Unless you have a full Progress license or the SDK then you can not directly add, update, or delete records from code (well service connect can using the business objects, but I wouldn't call it a direct approach). With the Updatetablebuffer.p you can update a record, but I don't think it can add or delete a record. Here is some code I got a while back on deleteing data in a dataset. Its a VB customization so I don't know if it will meet your needs.

This is for UD20, but just change to whatever table you need
call the sub and pass it the dataset or incorporate into a button click
or whatever - this is merely for concept :o)

Private Sub deleteUD20Records( dsUD20 As DataSet)
Dim adUD20 As UD20Adapter = New UD20Adapter( UD20Form)
adUD20.BOConnect( )
For Each dr As DataRow In dsUD20..Tables( 0).Rows
Dim deleted As Boolean = adUD20.DeleteByID( dr("Key1" ),dr
("Key2"),dr( "Key3"),dr( "Key4"),dr( "Key5"))
Next
adUD20.Dispose( )
End Sub

Â
MORE CODE:
Private Sub cedEpiCustom1_DoubleClick(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles cedEpiCustom1.DoubleClick
  '// ** Place Event Handling Code Here **
Â
  Dim edvOrderDtl As EpiDataView = CType(oTrans.EpiDataViews("OrderDtl"), EpiDataView)
    Dim I as Int32
    Dim TempRow as Int32
  If edvOrderDtl.Hasrow Then
           if 6 = msgbox("Would you like to update the Winco Price for all items on this Sales Order?",36,"Update Winco Calculated Pricing")
         TempRow = edvOrderDtl.row
            for I = 0 to edvOrderDtl.DataView.Count - 1
                   edvOrderDtl.Row = I
          edvOrderDtl.dataView(edvOrderDtl.Row)("SellingQuantity") = edvOrderDtl.dataView(edvOrderDtl.Row)("SellingQuantity")
            Next I
        edvOrderDtl.row = TempRow
           End If
  End If
Â
 End Sub



________________________________
From: mmcwilliams22 <mmcwilliams22@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 15, 2009 9:53:05 AM
Subject: [Vantage] Re: BMP Delete Row

Â
I guess I must do it throught the updatetablebuffer somehow. I am getting this error using your method.

The following application error was encountered:

You may not compile programs that update the database in this version (490)
** Could not understand line 11. (196)

--- In vantage@yahoogroups .com, Dimitris Kavvouras <d.kavvouras@ ....> wrote:
>
> Hi Williams ,
>
> Do you mean something like that? you don't need to specify any parameters, just fetch the record you wish to delete and delete it.
> i.e. just as an example, delete all records from JobEntry where company is the CUR-COMP (Current selected company) and field "Somehting" equals no.
>
> FOR EACH ttJobEntry where ttJobEntry.Company = CUR-COMP:
> if ttJobEntry.somethin g= false then
> delete ttJobEntry.
> end.
>
> ____________ _________ _________ __
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of mmcwilliams22
> Sent: Tuesday, September 15, 2009 4:05 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] BMP Delete Row
>
>
>
> How can I delete a row using a BPM I know it is DELETE but I am not sure of parameters etc.
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
We do have the SDK. Have never used it since we have been able to do almost everything with script and BPMs. Guess it is time to learn. I know Epicor wants to charge a hefty fee for training, I wonder how far the manuals will get me?


--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> Unless you have a full Progress license or the SDK then you can not directly add, update, or delete records from code (well service connect can using the business objects, but I wouldn't call it a direct approach). With the Updatetablebuffer.p you can update a record, but I don't think it can add or delete a record. Here is some code I got a while back on deleteing data in a dataset. Its a VB customization so I don't know if it will meet your needs.
>
> This is for UD20, but just change to whatever table you need
> call the sub and pass it the dataset or incorporate into a button click
> or whatever - this is merely for concept :o)
>
> Private Sub deleteUD20Records( dsUD20 As DataSet)
> Dim adUD20 As UD20Adapter = New UD20Adapter( UD20Form)
> adUD20.BOConnect( )
> For Each dr As DataRow In dsUD20..Tables( 0).Rows
> Dim deleted As Boolean = adUD20.DeleteByID( dr("Key1" ),dr
> ("Key2"),dr( "Key3"),dr( "Key4"),dr( "Key5"))
> Next
> adUD20.Dispose( )
> End Sub
>
> Â
> MORE CODE:
> Private Sub cedEpiCustom1_DoubleClick(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles cedEpiCustom1.DoubleClick
> Â Â '// ** Place Event Handling Code Here **
> Â
> Â Â Dim edvOrderDtl As EpiDataView = CType(oTrans.EpiDataViews("OrderDtl"), EpiDataView)
> Â Â Â Â Dim I as Int32
> Â Â Â Â Dim TempRow as Int32
> Â Â If edvOrderDtl.Hasrow Then
> Â Â Â Â Â Â Â Â Â Â Â if 6 = msgbox("Would you like to update the Winco Price for all items on this Sales Order?",36,"Update Winco Calculated Pricing")
> Â Â Â Â Â Â Â Â Â TempRow = edvOrderDtl.row
> Â Â Â Â Â Â Â Â Â Â Â Â for I = 0 to edvOrderDtl.DataView.Count - 1
> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â edvOrderDtl.Row = I
> Â Â Â Â Â Â Â Â Â Â edvOrderDtl.dataView(edvOrderDtl.Row)("SellingQuantity") = edvOrderDtl.dataView(edvOrderDtl.Row)("SellingQuantity")
> Â Â Â Â Â Â Â Â Â Â Â Â Next I
> Â Â Â Â Â Â Â Â edvOrderDtl.row = TempRow
> Â Â Â Â Â Â Â Â Â Â Â End If
> Â Â End If
> Â
> Â End Sub
>
>
>
> ________________________________
> From: mmcwilliams22 <mmcwilliams22@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, September 15, 2009 9:53:05 AM
> Subject: [Vantage] Re: BMP Delete Row
>
> Â
> I guess I must do it throught the updatetablebuffer somehow. I am getting this error using your method.
>
> The following application error was encountered:
>
> You may not compile programs that update the database in this version (490)
> ** Could not understand line 11. (196)
>
> --- In vantage@yahoogroups .com, Dimitris Kavvouras <d.kavvouras@ ....> wrote:
> >
> > Hi Williams ,
> >
> > Do you mean something like that? you don't need to specify any parameters, just fetch the record you wish to delete and delete it.
> > i.e. just as an example, delete all records from JobEntry where company is the CUR-COMP (Current selected company) and field "Somehting" equals no.
> >
> > FOR EACH ttJobEntry where ttJobEntry.Company = CUR-COMP:
> > if ttJobEntry.somethin g= false then
> > delete ttJobEntry.
> > end.
> >
> > ____________ _________ _________ __
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of mmcwilliams22
> > Sent: Tuesday, September 15, 2009 4:05 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] BMP Delete Row
> >
> >
> >
> > How can I delete a row using a BPM I know it is DELETE but I am not sure of parameters etc.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>